Excel: Countifproblem

I have a column of data which includes numbers, some of these numbers may be repeated. I need to count how many times a number appears twice for all numbers. EG 1 1 1 2 3 2 4 The answer would be 2 AS the number 1 appears more than once and the number 2 appears more than once. Therefor the answer will be 2. Could anyone help me with a formula please?

This question generated 24 answers. To proceed to the answers, click here.

This thread is current as of April 30, 2014.

For more resources for Microsoft Excel