Hi all,
I would like to check for duplicates values horizontally
Example: I need to check on 1st June to see if there are more than 1 employee going down to an event on that particular day.
I want to filter out that only 1 person is allowed at 1 event on 1st June.
Is there any formula to use or any way that i can check/trace this?
I try conditional formatting but it also checks for the rest of the month like 2nd June onwards. So i doubt that would work for my scenario.
Thanks in advance.
Bookmarks