Posted to microsoft.public.excel.worksheet.functions

Mac

external usenet poster

Posts: 213

Finding duplicates in distinct ranges...

I have like 300 columns with 50 values in each and I want to find duplicates
accross these groups - e.g. number 23,5366 appears in group no. 23, in group
no. 45, in group no. 145 twice, etc. - and I needto get back the row
reference of these duplicates ( conditional highlighitng would sufice). How
can I achieve this?

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
Finding Non-Duplicates	calibansfolly	Excel Worksheet Functions	2	July 16th 07 04:40 PM
help...finding duplicates	mj	Excel Worksheet Functions	3	March 9th 06 06:41 PM
Finding Duplicates	TLT	Excel Worksheet Functions	2	February 23rd 06 04:06 PM
Finding duplicates	Ted Metro	Excel Worksheet Functions	2	November 21st 05 07:09 PM
Finding Duplicates	fluffy	Excel Worksheet Functions	2	September 16th 05 03:07 PM

All times are GMT +1. The time now is 10:41 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us