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?
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?