Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Unique Values by Date Range | Excel Worksheet Functions | |||
Counting Unique Alpahnumeric's in a list | Excel Worksheet Functions | |||
Counting Unique Part Numbers In A Range | Excel Worksheet Functions | |||
counting unique entries in a list | Excel Discussion (Misc queries) | |||
Counting unique text/number cells from a range | Excel Discussion (Misc queries) |