Posted to microsoft.public.excel.programming

JCO

external usenet poster

Posts: 54

Remove Duplicates (Macro)

Using Excel 2007.
I need to be able to select a series of cells in a single column and count
the unique data (no duplicates). The existing cell format is "General".
Currently each cell is a hyperlink in the format shown below:
1-2323456
1-4345356
1-5454232
1-2323456

If these cells are selected, the answer should be 3 (because top and bottom
are the same).
Thanks

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
remove duplicates	asol	Excel Programming	1	May 5th 10 10:24 PM
How to remove row duplicates	SNAP TO GUIDES DON''T SNAP	Excel Discussion (Misc queries)	1	September 10th 08 10:28 PM
remove duplicates macro ending sub	Susan	Excel Programming	8	September 22nd 06 12:58 PM
remove duplicates	jeff quigley	Excel Programming	1	June 9th 05 03:13 PM

All times are GMT +1. The time now is 08:27 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us