View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Peter[_8_] Peter[_8_] is offline
external usenet poster
 
Posts: 27
Default Counting Inbetween Spaces

If I have a column that likes like this:

5
5
6
2 4

2
3
2 3

1 1

2
3
1 3


I want to count each the number of items in each group and have it
show up next to it's group as in the example. I assume it's some kind
of array formula similar to summing the numbers in each group.

Thanks very much for all of the help. I really do appreciate it.
This is great group.