On Tue, 19 Apr 2005 22:04:03 -0700, "stacyjhaskins"
wrote:

Your formula looks it would be simple to follow. I pluged in my cell
references,

=IF(COUNT(X33:IV33)=0,"No
Show",INDEX($X$29:$IV$29,1,MAX(ISNUMBER(X33:IV33) *COLUMN(X33:IV33))))

,but I got #value! as a result. Did I type something wrong?

Thanks in advance for your help.

I'm not sure. I can't reproduce the error with what I think are your inputs.

Did you enter this as an array formula with <ctrl<shift<enter or did you
just enter it as a normal formula with <enter?

If that does not correct it, (and on my sheet it does not cause an error), send
me a copy of the worksheet and I'll see what's going on. You may email it to
me at:

moc.enilonodlefnesorTAzyx

Reverse the above and make the obvious substitution.


--ron