View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JN[_2_] JN[_2_] is offline
external usenet poster
 
Posts: 6
Default Getting a unique list, then counting in a range

I have a bunch of blocks of 5 x 5 that look like this:

1,3,7,3,7
2,7,3,7,2
2,4,8,8,2
1,2,8,4,7
1,4,7,4,2

What I want to do is have a summary of the count of each value like the
following:

Item Count
1 3
2 6
3 3
4 4
7 6
8 3

I know I can do a CountIf by just creating the item list myself, but I would
like the timelist to autogenerate as well.