Count Unique Records

[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

 

[Gary''s Student]

=COUNTIF(B:B,"Houston")
=COUNTIF(B:B,"Dallas")

 

[gls858]

How can I count the number of stores per region?

Store # City


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

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

 

[M Kan]

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