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

Count Unique Records
 

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

--
Gary''s Student - gsnu200796


"CTAY" wrote:

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

Count Unique Records
 

CTAY wrote:
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

Count Unique Records
 

You could also generate a pivot table. If you use shortcuts, you can
generate this in less than 15 seconds
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"gls858" wrote:

CTAY wrote:
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