I am doing a roster and would like to know how to do a function to make
sure cells certain cells have names present
eg. cells a1 : a5 should have names present - is there a function in
say a6 that if all cells (a1:a5) have a name present a6 = true, and if
any cell has no name present a6 = false (or any other text)
I want this to make sure all cells are filled in with a name
andrewm


--
andrewm
------------------------------------------------------------------------
andrewm's Profile: http://www.excelforum.com/member.php...o&userid=23130
View this thread: http://www.excelforum.com/showthread...hreadid=377637