Posted to microsoft.public.excel.misc

backmara

external usenet poster

Posts: 13

Calculating duplicates

Hi all,
How I calculating duplicates in excel?
Example:
A1: 1
A2: 2
A3: 2
A4: 3
A5: 3
A6: 3
A7: 4
Answer: How many duplicates: A8: 3
Answer: How many unique values: A9: 4

I meen, what kind of functions I need?
This is same function that tool "Remove Duplicates" but I need automatic
information in Excel cells.

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
Condensing a list with duplicates to a list with non-duplicates	Nuclear	Excel Worksheet Functions	2	July 29th 08 08:03 PM
Duplicates in excel that aren't 100% DUPLICATES ...	[email protected]	Excel Discussion (Misc queries)	4	May 2nd 08 06:43 PM
duplicates	He cries for help[_2_]	Excel Discussion (Misc queries)	1	February 12th 08 07:43 AM
Duplicates	Pammy	Excel Discussion (Misc queries)	2	April 10th 07 11:00 AM
Calculating recurring date in following month, calculating # days in that period	Walterius	Excel Worksheet Functions	6	June 4th 05 11:21 PM

All times are GMT +1. The time now is 06:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us