count distinct numbers
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 count distinct number of ppl offshore and
onsite...
do i need some formula or some code for this...
pls explain its very imp....
|