Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |