Posted to microsoft.public.excel.misc

Johnny

external usenet poster

Posts: 126

Don't Count Duplicates

Here's a subset of 3 colunms of data:

Zip Code Name County
42125 John Franklin
42156 John Fairfield
43123 Bill Fairfield
45612 Jane Fairfield
45126 Jane Franklin
49856 Jane Fairfield
45895 Chris Fairfiled
46289 Chris Fairfield
42194 Chris Fairfield
42312 Chris Franklin

I am looking for a formual to count the number of people assigned to each
Territory.

The answer based on thes sample data above would be:

Fairfield - 4
Franklin - 3

Thank you

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
Count duplicates once	Tinkerbell1178	Excel Discussion (Misc queries)	2	December 1st 10 01:42 PM
Count Duplicates	saman110 via OfficeKB.com	Excel Discussion (Misc queries)	5	September 27th 07 06:04 PM
Count Employee Work Time - Don't Count Duplicates	J	Excel Worksheet Functions	3	May 1st 07 10:47 PM
Count Duplicates	Jonathan	Excel Discussion (Misc queries)	2	April 8th 05 03:23 PM
count a group of numbers but do not count duplicates	Lisaml	Excel Worksheet Functions	2	January 26th 05 11:19 PM

All times are GMT +1. The time now is 11:39 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us