G
Guest
Worked like a charm!!! Thanks!!!!!
Nobody said:
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Aladin Akyurek
What value does
=LOOKUP(2,1/(E6:E4000<>""),E6:E4000)
in contrast to
=LOOKUP(9.99999999999999E+307,E6:E4000)
which appears to return a real 0?
=LOOKUP(2,1/(E6:E4000<>""),E6:E4000)
in contrast to
=LOOKUP(9.99999999999999E+307,E6:E4000)
which appears to return a real 0?
A
Aladin Akyurek
What value does
=LOOKUP(2,1/(E6:E4000<>""),E6:E4000)
in contrast to
=LOOKUP(9.99999999999999E+307,E6:E4000)
which appears to return a real 0?
=LOOKUP(2,1/(E6:E4000<>""),E6:E4000)
in contrast to
=LOOKUP(9.99999999999999E+307,E6:E4000)
which appears to return a real 0?
P
PHOnos
< Lookup(L:L,E:E) > should return the data in the last cell of column E.
That said, sometimes it works, sometimes it doesn't and I don't know why.
That said, sometimes it works, sometimes it doesn't and I don't know why.
T
T. Valko
=LOOKUP(9.99999999999999E+307,E6:E4000)
That formula ignores empty cells (unless *every* cell in the range is
empty).
If you're getting a result of 0 then 0 is the last number in the range but
you may have turned off 0 display or maybe there's a custom/conditional
format set to hide 0s.
My result shows up as zero if cell E4000 has nothing in it.
That formula ignores empty cells (unless *every* cell in the range is
empty).
If you're getting a result of 0 then 0 is the last number in the range but
you may have turned off 0 display or maybe there's a custom/conditional
format set to hide 0s.