| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Showing duplicates in pivot tables | Excel Worksheet Functions | |||
| Date showing incorrect. 30:00 hrs showing 06:00 | Excel Discussion (Misc queries) | |||
| Multiple combo boxes with unique duplicates showing only | New Users to Excel | |||
| Showing a unique random number w/o duplicates | Excel Worksheet Functions | |||
| Showing/ not showing "getting started" when excel starts | Excel Discussion (Misc queries) | |||
Linear Mode
