Showing duplicates
 

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

Showing duplicates
 

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

you use "Reference" in pl;ace of "Sheet2"
--
Gary''s Student - gsnu200768


"Neil" wrote:

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