I have exported from Sage accounts package an extensive list of supplier invoices as I believe there are many duplicates.

the most logical approach I can think of is to insert a formula in column AB that will:

look at the purchase invoice reference number in column G, the date of the invoice in column D, and the amount of the invoice in column P, then search the rest of the data for matches for all three values in the same row and return "Duplicated" or something to that effect.

I have attached some sample data that contains duplicated lines in rows 5 and 6.

Any ideas?

Thanks in advance.
Dan.

Test.xls