RE: Finding duplicates in Multiple Columns

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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
.

Relevant Pages

  • OT: More Blast! Marketing
    ... The "essence of a color" - whether or not it's evident to everyone (or even ... Now, in the twilight of its final secondary-market tour, the show opens ... Jones, who is also the show?s assistant conductor, said the performance uses ... It sort of takes ...
    (rec.arts.marching.drumcorps)
  • Re: processing a large textfile
    ... The below is giving me context errors when i put ... Currently i don't need the regex part and sorting i want to sort the ... To sort and remove duplicates use, ... duplicate entries, from the error i'm getting there are something like ...
    (comp.unix.shell)
  • Re: Inserting a bunch of rows at once.
    ... can be sorted, and that only one entry per sort key would have been ... Microsoft MVP - Excel ... > the duplicate is where you want the blank row) ... > 7) Remove the filter - you should have desired result ...
    (microsoft.public.excel.misc)
  • Re: Need help sorting images.
    ... Do you want to sort a lot of images and then copy or move them ... Or are they already in subfolders and you want ... You'd still want a tool such as uniq to handle duplicate ... Because two cameras were used and one camera was left on PDT, ...
    (rec.photo.digital)
  • Re: Need help sorting images.
    ... In Windows Explorer add "Date Picture Taken" to the columns of the ... :>> I have been asked to sort a lot of images into subfolders based ... You'd still want a tool such as uniq to handle duplicate ... Because two cameras were used and one camera was left on PDT, ...
    (rec.photo.digital)