Thread: Count Unique Records
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
CTAY CTAY is offline
external usenet poster
  
Posts: 1
Default Count Unique Records
How can I count the number of stores per region?

Store # City
1 Houston
1 Houston
1 Houston
4 Dallas
4 Dallas

I want to see the results of Houston = 3 and Dallas = 2
Reply With QuoteReply With Quote