Posted to microsoft.public.excel.misc

Rod

external usenet poster

Posts: 108

check for duplicates

Hi all,
I have the data as shown below
col A col B
1 a
2 a
3 a
1 a
1 b
2 b
Is there any formula to find duplicates( 1st and 4th rows are duplicates)
are there or not?
I am using the sumproduct formula in supporting column C
But I need the formula in C1 which displays "Duplicates" if there are or
else "No duplicates"
Thanks in advance

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
Check for duplicates?	Vass[_2_]	Excel Worksheet Functions	5	October 24th 07 11:12 PM
check for duplicates	Todd	Excel Worksheet Functions	0	November 7th 06 05:59 PM
Check for Duplicates	Carter68	Excel Worksheet Functions	3	April 15th 06 12:13 AM
Check for Duplicates	nebb	Excel Worksheet Functions	2	February 13th 06 02:39 PM
Check for duplicates	Pat	Excel Worksheet Functions	8	February 17th 05 10:06 PM

All times are GMT +1. The time now is 02:49 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us