Identify duplicate invoice records in excel

[ajay.happiness]

Dear Chandoo,

I would like to know how to find duplicate invoice records on a sheet? Duplicate invoices based on OFF No, OFF From,Cost Center,Customer Code,Customer Name. I would like to list the original invoice and the duplicates.

 

[Luke M]

Chandoo has posted several articles about finding duplicates, perhaps they will work? If you have special circumstances, it would help if you could post a sample of what your data looks like (use ` marks to surround the spreadsheet data so spacing is preserved).


Or, you can just click here

=)

 

[Debraj]

wow.. that was cool URL..

 

[Montrey]

hahah @Luke.


Seriously some people.... Google can answer almost every question in your life. Or at least put you on the right track

 

[ajay.happiness]

Thanks Luke