Showing duplicates

  • Thread starter Thread starter Neil
  • Start date Start date
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
 
=IF(AND((Sheet1!E5=Sheet2!E5),(Sheet1!H5=Sheet2!H5)),"DUP","")

you use "Reference" in pl;ace of "Sheet2"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel A CountIF question... I think 2
Count how many different cells are in a range 1
I need a formula. 3
How can I search for words in a list with a macro? 4
Duplicates Deletion ? 2
Formula Mystery 4
My Never ending ARRAY code problems 18
Excel vba code to match duplicates 4

Back
Top