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 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.