Count Unique Records

  • Thread starter Thread starter CTAY
  • Start date Start date
C

CTAY

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
 
CTAY said:
How can I count the number of stores per region?

Store # City


I want to see the results of Houston = 3 and Dallas = 2
Click to expand...

another method would be to sort by store# or city and then use the
subtotal function and select count. The result would be something
like this

1 Houston
1 Houston
1 Houston
Houston Total 3
4 Dallas
4 Dallas
Dallas Total 2

gls858
 
You could also generate a pivot table. If you use shortcuts, you can
generate this in less than 15 seconds
 
Back
Top