Thread: Count but ignore duplicate data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rechie Rechie is offline
external usenet poster
  
Posts: 57
Default Count but ignore duplicate data
Hi Expert, I need your help on how to count data but to ignore duplicates.

Below count results should be = 3 (ignore duplicates)
Inv No.
9123
9123
9125
9128
9128

Thanks for your support,
Reply With QuoteReply With Quote