Posted to microsoft.public.excel.misc

Tinkerbell1178 Tinkerbell1178 is offline

external usenet poster

Posts: 3

Count duplicates once

I need to count how many different codes/numbers are in a list, and some of
them are duplicated. eg:

300001600
300001600
300002465
300001435
300005642

I need the result to show that there are 4 different numbers, rather than 5
in total.

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 Table- how do I eliminate duplicates in count of name	Isabelga	Excel Discussion (Misc queries)	1	January 16th 06 06:15 PM
Count excluding Duplicates	GRM via OfficeKB.com	Excel Worksheet Functions	12	November 15th 05 09:07 PM
Count Duplicates	Jonathan	Excel Discussion (Misc queries)	2	April 8th 05 03:23 PM
Count 350 SS numbers, exclude duplicates	Marsha	Excel Discussion (Misc queries)	5	March 7th 05 05:49 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 09:52 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us