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