Neither worked. And Don, I am not even sure what your response means since
it is not an equation.

Thanks-

"daddylonglegs" wrote:


Try

=LOOKUP(REPT("z",255),J3:IV3)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=563487