Finding duplicates in Multiple Columns
Worked on my machine
"JCS" wrote:
Hey Teethless mama,
Thanks for the help, but it didn't work. I appreciate the help!
John
"Teethless mama" wrote:
Try this:
=IF(ISERR(SMALL(IF((ISNUMBER(MATCH(Field_1,Field_2 ,0))*(ISNUMBER(MATCH(Field_1,Field_3,0)))),ROW(IND IRECT("1:"&ROWS(Field_1)))),ROWS($1:1))),"",INDEX( Field_1,SMALL(IF((ISNUMBER(MATCH(Field_1,Field_2,0 ))*(ISNUMBER(MATCH(Field_1,Field_3,0)))),ROW(INDIR ECT("1:"&ROWS(Field_1)))),ROWS($1:1))))
ctrl+shift+enter, not just enter
copy down
"JCS" wrote:
Good Morning All,
I have a spreasdheet with 3 columns. I would like to find the duplicate
entries in all 3 columns. I can find duplicate entries in 2 columns using
the Index and Match functions but don't know haw to find duplicates in 3
columns. Enclosed is a sample of what I would like to do:
Field 1 Field 2 Field 3 Duplicates
smith jones ellis ellis
ellis myers jacobs
daniles ellis gates
Any suggestions would be greatly appreciated. Thanks in advance!
John
|