Posted to microsoft.public.excel.newusers

CTAY

external usenet poster

Posts: 1

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
pivot count unique records only	Deborah	Excel Discussion (Misc queries)	0	July 8th 08 01:52 PM
Unique Records Count with AutoFilter	Danni2004	Excel Worksheet Functions	1	May 16th 08 09:56 PM
Count Unique Records	Jon Dow[_2_]	Excel Worksheet Functions	4	February 26th 07 05:28 AM
Count unique records... with a twist... Need help!	[email protected]	Excel Worksheet Functions	4	August 3rd 06 06:17 PM
Count the number of unique records	[email protected]	Excel Worksheet Functions	7	March 8th 06 07:33 AM

All times are GMT +1. The time now is 04:16 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us