Thread: Counting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jason30 Jason30 is offline
external usenet poster
  
Posts: 5
Default Counting
HOw do I count the number of unique cells whilst excluding those which have
identical values? I.e.

Col A

1234
1234
3456
4567

The number of unique numbers is 4 (as the first 2 are the same)
Reply With QuoteReply With Quote