| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
count distinct numbers
thanks... but i cant find a way for this.... can u pls elaborate the
method... On May 10, 8:00 pm, "Don Guillett" wrote: IF??? I understand your desires, look in the help index for COUNTIF -- Don Guillett SalesAid Software "rishi" wrote in message ups.com... i have some data as follows PLACE id number 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 please tell me how do i countdistinctnumber of ppl offshore and onsite... do i need some formula or some code for this... pls explain its very imp....- Hide quoted text - - Show quoted text - |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Distinct Count with Criteria | Excel Discussion (Misc queries) | |||
| Count Distinct | Excel Discussion (Misc queries) | |||
| Count Distinct only | Excel Discussion (Misc queries) | |||
| Count Distinct Values? | Excel Worksheet Functions | |||
| Count distinct | Excel Worksheet Functions | |||
Threaded Mode
