marking duplicate rows

  • Thread starter Thread starter dely77
  • Start date Start date
D

dely77

Hello,

I have an interesting task which involves marking duplicates.

I have a workbook with 7 identifying columns and the rest of the
columns have some sort of pricing in them.

I have 6000+ rows of data.

Since I am adding new pricing to this file I want to be able to
identify which rows are now duplicates with new pricing.

I.E.

Origin Country - Origin City - Origin Airport - Dest Country - Dest
City - Dest Airport - Service Type

These are the 7 identifying markers. My goal would be to be able to
mark a row when it is a duplicate so that I can identify the old
pricing and eventually replace the row with the new pricing. It may
seem a little confusing but I hope I explained it ok.

Thanks for any help.
 
I'd create a new column that concatenates the other 7 into one giant string.

Then I'd use that column to look for duplicates.

I'd use:
=a2&".."&b2&".."&c2&".."&d2&".."&e2&".."&f2&".."&g2

I used .. to separate each field.

Then I could use the techniques that Chip Pearson shares to find duplicates:
http://www.cpearson.com/excel/duplicat.htm
 
Back
Top