Duplicated information

Hi Lillian

Thank you for using our forum

Have you tried using conditional formatting? It won't mark it with the word match but it will mark all duplicate entries a certain colour making it easier to identify.

Another method you could use is sorting the data by Column D and in Column E use an IF statement to check if it's a duplicate and if it is to add the word match

=IF(A8=A9,"Match","")

Though this option would only work if you kept the data sorted

Hope this helps

Kind regards
Wendy Canelas
Microsoft Office Trainer