IF(COUNTIF(Thursday,"John Doe")>1,"error"," ")

J

jayd77

I am trying to count the number of times an employee's name appears i
Thursday's employee schedule to make sure an employee was not actuall
scheduled twice in the same day. IF(COUNTIF(Thursday,"Joh
Doe")>1,"error"," ")

My formula works fine if I am looking up just last names but when I us
a first and last name due to multiple employees with the same las
name(ie John Doe, Allen Doe, Rick Doe) my formula does not show a
error if an employee is working twice in the same day.

Any help would be appreciate
 
R

Roger Govier

Hi

Your formula works fine for me. I get the error for any duplicate occurrence
of John Doe with or without any prefix or suffix.

Regards

Roger Govier
 
J

jayd77

I think I have been sitting in front of the computer for too long. I had
a Ted Myers and a Rick Meyers. I was typing Rick Meyers as Rick Myers.

Thanks for the help!
 
Top