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 -