I am trying to count the number of times an employee's name appears in Thursday's employee schedule to make sure an employee was not actually scheduled twice in the same day. IF(COUNTIF(Thursday,"John Doe")>1,"error"," ")
My formula works fine if I am looking up just last names but when I use a first and last name due to multiple employees with the same last name(ie John Doe, Allen Doe, Rick Doe) my formula does not show an error if an employee is working twice in the same day.
Any help would be appreciated
Bookmarks