Thread: Count occurences over range if a certain criteria met
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Richhall[_2_] Richhall[_2_] is offline
external usenet poster
  
Posts: 41
Default Count occurences over range if a certain criteria met
Excellent thank you, how do I count Unique entries please? Request has
moved on a notch!

i.e

Server A New1
New 1 New 2
Server B new 3
new 2 new 1

Would return 3.

Thank you

Rich
Reply With QuoteReply With Quote