Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count if unique entries
I need to count the number of unique entries (names) in a column of data, one
count for each different name. List changes throghout the day and so I can't keep putting names in a long 'countif' formula. Am looking for something that will identify a unique entry and count it. This type of list: Doctor Mahoubi, Ray Corcoran, David Aguilera, Ruben Green, Kerry S. Aguilera, Ruben Sarraf, Payam Murad, Craig A. Murad, Craig A. Murad, Craig A. Murad, Craig A. Murad, Craig A. Murad, Craig A. Thull, David A. Murad, Craig A. Murad, Craig A. Crezee, Kelvin S. Gorman, Ike B. Gorman, Ike B. Gorman, Ike B. Sarraf, Payam Turner, Merle C. Turner, Merle C. Turner, Merle C. Jensen, Scott M. Turner, Merle C. Turner, Merle C. Jensen, Scott M. Discont, Alan J. Discont, Alan J. Discont, Alan J. Discont, Alan J. Pawlowski, Jeff V. Pawlowski, Jeff V. Pawlowski, Jeff V. Jacoby, Richard Jacoby, Richard Jacoby, Richard Jacoby, Richard Jacoby, Richard Beecroft, C. Jon Beecroft, C. Jon Sapin, Neil J. Aguilera, Ruben Mehta, Kishor D. Aguilera, Ruben Green, Kerry S. Green, Kerry S. Green, Kerry S. Hoang, Phat D. Hoang, Phat D. Freed, Lewis H. Freed, Lewis H. Mehta, Kishor D. Mehta, Kishor D. Jacoby, Richard Thull, David A. Thull, David A. Thull, David A. Jensen, Scott M. Turner, Merle C. Turner, Merle C. Turner, Merle C. Discont, Alan J. Krand, Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count unique entries... | Excel Worksheet Functions | |||
Count Unique Entries | Excel Worksheet Functions | |||
Count unique entries | Excel Discussion (Misc queries) | |||
Count unique entries | Excel Worksheet Functions | |||
Count of unique entries | Excel Discussion (Misc queries) |