| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting in Excel
I have a spreadsheet in which duplicate data appears multiple times in
groups. I would like to count each occurence. Ex. 12345 12345 12345 12345 78912 78912 78912 78912 78912 expected result is that each occurence is counted once. 12345 occurs once 78912 occurs once I do not want to use a pivot table because each 'group' has multiple rows of data that needs to be shown. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting function but not double counting duplicates | Excel Worksheet Functions | |||
| Excel Counting!! | Excel Discussion (Misc queries) | |||
| Counting in Excel | Excel Discussion (Misc queries) | |||
| Counting with Excel | Excel Discussion (Misc queries) | |||
| Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
Threaded Mode
