| Home |
| Search |
| Today's Posts |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding & Replacing a list of Data in Multiple Columns | Excel Worksheet Functions | |||
| Finding duplicates based on 2 columns | Excel Worksheet Functions | |||
| Finding Duplicates | Excel Worksheet Functions | |||
| Finding Duplicates | Excel Worksheet Functions | |||
| Finding common data in multiple columns and rows in Excel | Excel Worksheet Functions | |||
Threaded Mode
