how to count distinct values???/

  • Thread starter Thread starter rishi
  • Start date Start date
R

rishi

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!!!!!!!!!
 
Its utterly important to be clear if you expect an answer. How is
anyone suppose to conclude "9 offshore" and "8 onsite" from the many
lines you posted? One might conclude "9 offshore" because that is the
last data for "offshore"; however, 8 is not the last data for
"onsite".

Merjet
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count distinct numbers 5
how to find and copy cells between sheets?? 2
find and copy cells 4
Sumif....date in table is greater than compared to date 1
[Info] Programmers Search Engine 1
WCG Stats Friday 22 September 2023 3
WCG Stats Wednesday 27 September 2023 3
WCG Stats Tuesday 01 August 2023 2

Back
Top