View Single Post
  #1   Report Post  
Old May 11th 15, 05:10 PM posted to microsoft.public.excel.worksheet.functions
[email protected] dale.laing@calgary.ca is offline
external usenet poster
 
First recorded activity by ExcelBanter: May 2015
Posts: 8
Default Find duplicates w/3 criteria

I have tried various formulas to make this work and I'm spinning my wheels and hoping for help!
I would like in column D a Y or N to indicate the cells in that row are duplicates because they show up elsewhere in that column.
ROW Col A ColB ColC ColD
Dt Tmstamp Item ID Work Order Result
1 5/7/2015 14:20 142532 775502 N
2 5/7/2015 14:24 142416 775502 N
3 5/7/2015 14:25 142416 775502 Y
4 5/7/2015 14:25 142416 775502 Y
5 5/7/2015 14:25 142416 775502 Y
6 5/7/2015 14:48 171071 N

So rows 3, 4 and 5 are duplicates in my example would be the desired result of the formula which I'm trying to put into Column D. I have tried {=IF(ISNA(MATCH(1,($B145=sheet1!$B$1:$B$1000)*($D1 45=sheet1!$D$1:$D$1000)*($H145=sheet1!$H$1:$H$1000 ),0)),"n","Y")}, but all I get are Y's