View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
merjet merjet is offline
external usenet poster
 
Posts: 812
Default 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