(Solved) – If there is a duplicate in 1 column, check that both duplicates have a specific value in another column


I have a sheet with data extracted from a report – I need a macro to find duplicate reference numbers in column G, and with those duplicates, and for each duplicate check that they both have a “Y” in column N – if they do they add some text to column S.

E.g. there are 2 entries with ref “1600” in column G – for those 2 “1600” refs that are listed, check if they both have a “Y” in column N – and if they do, put “confirmed” in column S.

Leave a Reply

Your email address will not be published. Required fields are marked *