Help... I can't figure this out and have been trying for 2 days....
What I'm trying to do is look at three columns of information. If the "Date Worked" and "Name" columns are the same and if the "Time Type" columns has the "SB" which appears more than once for that given Date Worked and Name, then it would show as a duplicate. If there isn't a duplicate for the Date worked and name, it would then show as OK.
Untitled-1.jpg
Column N is Date worked in image.
The formula I have right now is
=IF(Q3="SB",IF(AND(N3=N2,O3=O2),"Duplicate","OK"))
We use to filter out all other Time Types, except for "SB" and were using this function
=IF(AND(N3=N2,O3=O2),"Duplicate","OK") - It worked perfectly. However, we're trying to verify multiple additional types of information which now includes multiple Time Types, and this will no longer work.
I probably going about this completely wrong and there is probably an easier way to do this, so any information or assistance would be greatly appreciated.
Bookmarks