"my" wrote:
.. Just out of curiosity, how does the LOOKUP
(9.99999999999999E+307,A1:F1) work?
...
"Bob Phillips" wrote:
=IF(COUNTA(A1:F1)=0,"",LOOKUP(9.99999999999999E+30 7,A1:F1))

Try the responder's excellent white paper at his:
http://www.xldynamic.com/source/xld.LastValue.html

(but don't ask me why Bob doesn't include a link to his site
in his sign-off <g)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---