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

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

--
jayd7
-----------------------------------------------------------------------
jayd77's Profile: http://www.excelforum.com/member.php...fo&userid=1904
View this thread: http://www.excelforum.com/showthread.php?threadid=47965

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


jayd77 wrote:
> I am allowing for information before and after the employee's name.
> 6am John Doe
> Rick Doe 9a-9p
>
> IF(COUNTIF(Thursday,"*"&"John Doe"&"*")>1,"error"," ")
>
>

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!


--
jayd77
------------------------------------------------------------------------
jayd77's Profile: http://www.excelforum.com/member.php...o&userid=19048
View this thread: http://www.excelforum.com/showthread...hreadid=479652