View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Antonio Antonio is offline
external usenet poster
 
Posts: 134
Default Consecutive occurences

Hi all

have data displayed on column C as follows:
3
5
4
5
3
4
4
2
4
3
4
4
3
5
6
4
4
3
3
4
2
3
2
4
4
4
4
4

Is there a way to count the large number of occurences of the same number,
which in this case should be number 4 five times??

Tks in advance