Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Establish detailed count function
Hi,
I need to count number of clients in a column. However, I encounter problem where a client's name will be shown more than once eg 3 times. So this make the counting not accurate as the client should still be counted once only. This happen to other clients also. Thus, pls help as my table consists of more than 5000 rows of name. Cheers Stephen Lim |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Establish detailed count function
See:
http://www.cpearson.com/excel/duplicat.htm "Stephen Lim" wrote: Hi, I need to count number of clients in a column. However, I encounter problem where a client's name will be shown more than once eg 3 times. So this make the counting not accurate as the client should still be counted once only. This happen to other clients also. Thus, pls help as my table consists of more than 5000 rows of name. Cheers Stephen Lim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display detailed data in a pop up box | New Users to Excel | |||
SUMPRODUCT to establish whether turnaround date was achieved | Excel Worksheet Functions | |||
Establish formula for multiple logical_tests | Excel Worksheet Functions | |||
Excel cannot establish a DDE with WORD | Excel Discussion (Misc queries) | |||
Can I establish a link based on a date? | Excel Worksheet Functions |