sorry , make sure that in the if statement, you would check for the other two

"Don" wrote:

try to copy the names in one colum and sort keeping the previous column name
=

A B
Field 1 Smith
Field 1 Ellis
Field 1 Danils
Field 2 Jones
Field 2 etc

Then when you sort by column B, you can put a formula in column C to check
if matched (maybe go as far as Data / Filter C)
=if(and(a1="Field 1",a2="Field 2",a3="Field3",A1=A2,A1=A3),"Match","no Match")

"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