Showing duplicates

N

Neil

i would like to be able to filter duplicates lines on my work sheet. I was
hoping to put something in column Z that when Column E and Column H match
Column E and Column H on a second sheet it can read "Dup".
It starts with Cell E5 and Cell H5 and my second sheet is called "Reference"

Many thanks
 
G

Gary''s Student

=IF(AND((Sheet1!E5=Sheet2!E5),(Sheet1!H5=Sheet2!H5)),"DUP","")

you use "Reference" in pl;ace of "Sheet2"
 
Top