Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Greetings,
I have a list of about 2 k entries that I need to get a count of unique numbers in column D. The twist, there are a few entries that are blank. I need to count each blank entry as a unique entry and add that number to the rest of the unique entries for column D. I read the article at http://www.cpearson.com/excel/duplicat.htm, but it did not address counting each blank as a unique entry only NOT counting the blanks or counting all of the blanks as duplicates of themselves. Is there anyway to count each blank as a separate entry along with all of the other non duplicating entries? Any help would be most appreciated. CIA -Minitman |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting unique entries in a field | Excel Worksheet Functions | |||
COUNTING UNIQUE ENTRIES IN FILTERATION | Excel Discussion (Misc queries) | |||
Counting Unique Entries | Excel Discussion (Misc queries) | |||
Counting unique entries | Excel Discussion (Misc queries) | |||
Counting Unique Entries | Excel Discussion (Misc queries) |