Posted to microsoft.public.excel.misc

Loris

external usenet poster

Posts: 39

Counting unique records in a field

In Excel 2003, I have a large list (database). In one of the fields I have
multiple company names. Each company may be listed many times. Is there a
way to count the number of different companies that are in that field? I
don't care how many times any one company appears, just how many different
companies there are.

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
Counting unique entries in a field	Jeff Whitesel	Excel Worksheet Functions	5	October 23rd 08 04:06 AM
Counting unique records	yhtak	Excel Worksheet Functions	6	June 16th 06 02:34 PM
Counting unique records based on date range	aspAddict	Excel Worksheet Functions	3	October 26th 05 08:12 PM
Counting unique records with additional criteria	[email protected]	Excel Worksheet Functions	4	September 27th 05 06:53 PM
Counting Unique Records with multiple conditions	Keithlearn	Excel Worksheet Functions	4	April 27th 05 12:44 AM

All times are GMT +1. The time now is 07:01 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us