Hello Everyone,
I have formula that works decently, I have it extracting across the row for about 15 columns. It extracts data from another sheet that has about 1200 rows, and some rows are duplicates.
=IF(ISNUMBER(SEARCH($J$29,'Sheet1'!$S:$S)),'Sheet1'!A:A,"")
But the problem is that it pulls completely duplicate rows which is what I'm trying to avoid. I want it to ignore duplicate rows only if it meets two match criteria's. The person's name is in column H and the shift is column J. I kinda hit a wall, and cant figure it out. I guess I may need < or > symbols possibly but not sure
Any help would be greatly appreciated.
MZING81
I have formula that works decently, I have it extracting across the row for about 15 columns. It extracts data from another sheet that has about 1200 rows, and some rows are duplicates.
=IF(ISNUMBER(SEARCH($J$29,'Sheet1'!$S:$S)),'Sheet1'!A:A,"")
But the problem is that it pulls completely duplicate rows which is what I'm trying to avoid. I want it to ignore duplicate rows only if it meets two match criteria's. The person's name is in column H and the shift is column J. I kinda hit a wall, and cant figure it out. I guess I may need < or > symbols possibly but not sure
Any help would be greatly appreciated.
MZING81