Function Help
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
|