| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to count distinct values???/
i have some data as follows
place id Offshore 1 Onsite 10 Onsite 11 Onsite 12 Offshore 2 Onsite 12 Offshore 3 Offshore 3 Onsite 13 Offshore 4 Offshore 5 Onsite 14 Offshore 4 Offshore 6 Offshore 6 Offshore 2 Offshore 7 Onsite 15 Onsite 10 Onsite 11 Onsite 15 Onsite 16 Onsite 17 Offshore 8 Offshore 9 please help me that how do i count distint number of ppl in offshore and onsite... eg in above case we have 9 people offshore and 8 people onsite....DO we have a direct function for this or it can only be done through coding... PLEASE HELP!!!!!!!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Ignore Hidden Rows and Count of distinct values | Excel Worksheet Functions | |||
| Count Distinct Values based on criteria | Excel Worksheet Functions | |||
| Formula to count distinct values not working in VBA | Excel Programming | |||
| Count Distinct Values? | Excel Worksheet Functions | |||
| Count Distinct Values by Group Using Pivot Table (NM) | Excel Worksheet Functions | |||
Threaded Mode
