Excel- any formula to return last number in a column

[Ebraham]

Hi.


In sheet one. In cell b20. I want to return last number of column d of sheet2.

 

[Aladin Akyurek]

Hi.


In sheet one. In cell b20. I want to return last number of column d of sheet2.

B20, just enter:

=LOOKUP(9.99999999999999E+307,Sheet2!D:D)

which delivers the last numeric value from column D.

In case the last text is wanted...

=LOOKUP(REPT("z",255),Sheet2!D:D)

If column D contains text and numbers and you want the last value (text or number, whichever is the case)...

B19:

=LOOKUP(REPT("z",255),Sheet2!D:D)

B20:

=IF(ISNA(B19),
    LOOKUP(9.99999999999999E+307,Sheet2!D:D),
    INDEX(Sheet2!D:D,MAX(MATCH(REPT("z",255),Sheet2!D:D),
    MATCH(9.99999999999999E+307,Sheet2!D:D)

The foregoing set ups are fast as intended.

See for more information: http://www.mrexcel.com/forum/excel-questions/102091-9-9999999-a.html.

 

[Ebraham]

All the formula worked well.


Just want to know what is 9.9E+307

 

[Aladin Akyurek]

All the formula worked well.


Just want to know what is 9.9E+307

Once more...

http://www.mrexcel.com/forum/excel-questions/102091-9-9999999-a.html