Posted to microsoft.public.excel.worksheet.functions

TLT

Posts: n/a

Finding Duplicates

I have a list..
505/1
505/2
505/3
I need to make sure that non of these numbers are duplicates of a master
list, I thought about something simple like:
=if(A1=z1:Z1000, "Duplicate").
This doesn't appear to work with a rang.

Can anyone help?

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 duplicates in Excel	Teri	Excel Discussion (Misc queries)	1	December 13th 05 09:56 PM
Finding duplicates	Ted Metro	Excel Worksheet Functions	2	November 21st 05 07:09 PM
Finding Duplicates	nospaminlich	Excel Worksheet Functions	4	February 5th 05 11:57 PM
Finding and Deleting duplicates in a column	Brian	Excel Worksheet Functions	3	February 5th 05 02:19 PM
Finding Duplicates and somehow flagging them in another column	KenRamoska	Excel Discussion (Misc queries)	1	January 31st 05 06:20 PM

All times are GMT +1. The time now is 07:17 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us