View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Neil Neil is offline
external usenet poster
 
Posts: 173
Default 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