Countif repeat

krishnanaik

Board Regular
Joined
Aug 5, 2005
Messages
81
I have been puzzled for a while.. I have a series of number and want to count how many times the number are repeated

E.G

10
10
25
29
30
25
12
15
12
12

Answer: 10 is repeated twice
25 is repeated twice
12 is repeated three times

etc

Please can you let me know the best formula to use to carry out this function.

Thanks

K
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Watch MrExcel Video

Forum statistics

Threads
1,119,272
Messages
5,577,133
Members
412,769
Latest member
VK12345
Top