| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot count unique records only | Excel Discussion (Misc queries) | |||
| Unique Records Count with AutoFilter | Excel Worksheet Functions | |||
| Count Unique Records | Excel Worksheet Functions | |||
| Count unique records... with a twist... Need help! | Excel Worksheet Functions | |||
| Count the number of unique records | Excel Worksheet Functions | |||
Linear Mode
