| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Unique Alpahnumeric's in a list
I have huge column of alphanumeric data, some duplicated in different lines.
I need to be able to count or sum the unique entries? Thanks, R. Rhoden |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting Unique Alpahnumeric's in a list
=SUMPRODUCT((A1:A110<"")/COUNTIF(A1:A110,A1:A110&""))
"aspenelk" wrote: I have huge column of alphanumeric data, some duplicated in different lines. I need to be able to count or sum the unique entries? Thanks, R. Rhoden |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Unique entry from Concatenated list | Excel Worksheet Functions | |||
| Unique counting | Excel Discussion (Misc queries) | |||
| Counting unique text entries in a filtered list... | Excel Worksheet Functions | |||
| counting unique entries in a list | Excel Discussion (Misc queries) | |||
| counting unique instances of text in a list | Excel Worksheet Functions | |||
Linear Mode
