Hi
Please can someone advise. I have a spreadsheet with consecutive references. Some of those references are duplicates. I have already got a formula to identify those duplicates. However, in a separate column named 'CERTIFICATE', there is an entry on some of the duplicate records. I would like to remove the duplicate record without the entry in the 'CERTIFICATE' column if that makes sense, and leave the record with the entry in intact. Can someone provide me with a formula which will identify the duplicate column without an entry in the 'CERTIFICATE' column so I can remove it please.
I have attached a copy of the spreadsheet.
Thank you.
Bookmarks