Bernie,
Thanx for all of your help in this. The dept. really appreciates this.
It works great!
I do have one more question though. I have figured out a small formula
that I want to have the results show in a seperate cell.
Example. Gustavo has 3 therefore he is Suspended
This is my formula... =IF(C5=3,"Suspended Player",""). And it
works...
My question now is... can there be a formula that says... If cell =""
then Over 5 Weeks OR if cell = 3 or more then Suspended Player?
Thanks again for the assistance.
T.
--
onesidered
------------------------------------------------------------------------
onesidered's Profile:
http://www.excelforum.com/member.php...o&userid=25977
View this thread:
http://www.excelforum.com/showthread...hreadid=393435