| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to get the number of unique records in a list
hello, Here is a sample of data that I have: CODE NAME LASTNAME TS19 Sylvain Brook TS19 Sylvain Brook TV04 Valérie Musoni TV04 Valérie Musoni VB05 Ben Valiquette VB05 Ben Valiquette VB05 Ben Valiquette VI02 Isabelle Vanasse VR07 Richard Vivo VR07 Richard Vivo VR07 Richard Vivo WD01 Dany Williams WD01 Dany Williams WD01 Dany Williams How can I quickly get the total number of employees from a list like this one? the first field is a unique key (1 code per employee) In this case, the desired result would be 6. (the count function does NOT give the desired result..) thank you!! louisp -- louisp ------------------------------------------------------------------------ louisp's Profile: http://www.excelforum.com/member.php...o&userid=25880 View this thread: http://www.excelforum.com/showthread...hreadid=511929 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select every 10th number in a list | Excel Discussion (Misc queries) | |||
| unique occurences in list | Excel Worksheet Functions | |||
| unique occurences in list | Excel Worksheet Functions | |||
| Pull unique names for drop down list | Excel Discussion (Misc queries) | |||
| Formula to list unique values | Excel Worksheet Functions | |||
Threaded Mode
