Add same sequence number for duplicates in the file
How do I add the same sequence number for duplicate files in excel 2007?
For example.. I have a list of 1400 orders. Some of them are duplicates and I can tell by their order number. I want to assign the duplicates the same sequential number so that I can sort out all the duplicates that are the same and move them to a new file.
Example of how i want it to look:
Customer Name BTN Order ID Seq Number
John Doe 2165551414 eftgr 1
Jane Doe 2165551413 eftgr 1
Thank you!!!!
How do I add the same sequence number for duplicate files in excel 2007?
For example.. I have a list of 1400 orders. Some of them are duplicates and I can tell by their order number. I want to assign the duplicates the same sequential number so that I can sort out all the duplicates that are the same and move them to a new file.
Example of how i want it to look:
Customer Name BTN Order ID Seq Number
John Doe 2165551414 eftgr 1
Jane Doe 2165551413 eftgr 1
Thank you!!!!