how to count distinct values???/
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
|