I have a large spreadsheet which is just 3 columns wide, each cell contains a postcode.
AB42 3JF AB42 3JF AB42 3JF
AB42 4HR EH17 7NQ EH17 7NQ
AB51 5EU G2 6HS G2 6HS
I am looking for a formula to identify any row in which the 3 postcodes are identical. For example, I would like the first row shown above flagged.
I would appreciate any suggestions!