Posted to microsoft.public.excel.worksheet.functions

Karen

external usenet poster

Posts: 447

Counting Unique Values

I have a range of cells (A5:A100). In some cells there are duplicate part
numbers. I want to count ONLY the unique values and not the duplicates. Does
anyone know how this can be done and what formula I would use to accomplish
this?
Thank you very much in advance, Karen

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 Values	Jordan	Charts and Charting in Excel	2	August 5th 09 07:09 PM
Counting unique values	blswes	Excel Worksheet Functions	4	August 14th 08 06:50 PM
counting the # of unique values	bobby769	Excel Worksheet Functions	3	January 10th 07 04:08 AM
Counting unique values	JK57	Excel Worksheet Functions	3	July 7th 06 01:02 AM
Counting Unique Values	carl	Excel Worksheet Functions	9	July 25th 05 12:44 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us