First column with non zero values
It's the largest number that can be held in a cell.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Richard Buttrey" wrote in
message ...
Thanks Tom,
That's an interesting one.
Just as a supplementary, what's the significance of the
9.99999999999999E+307
particularly the +307 bit?
Regards
On Tue, 18 Jan 2005 09:54:07 -0500, "Tom Ogilvy"
wrote:
From a post by Aladin Akyurek:
To fetch the last numerical value...
=LOOKUP(9.99999999999999E+307,C:C)
To determine the position of the last numerical value within column C...
=MATCH(9.99999999999999E+307,C:C)
To fetch the last text value...
=LOOKUP(REPT("z",255),C:C)
To determine the position of the last text value within column C...
=MATCH(REPT("z",255),C:C)
so in E1
=LOOKUP(9.99999999999999E+307,A1:D1)
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
|