Using last cell in a column

[mike12]

I was wondering how to put the last cell of a column in a formula so that it is always the last cell, even when I changed the number of rows on that worksheet. So If my last cell with data would be E20 it would use E20 in the formula for another cell. But if I add another row so the last cell with data is E21, that the formula would then use E21 instead of E20. Thanks!

[Domenic]

If your column contains numerical data...

=LOOKUP(9.99999999999999E+307,E:E)

If your column contains text data...

=LOOKUP(REPT("z",255),E:E)

If your column can contain numerical and text data...

=LOOKUP(2,1/(E1:E100<>""),E1:E100)

Hope this helps!

I was wondering how to put the last cell of a column in a formula so that it is always the last cell, even when I changed the number of rows on that worksheet. So If my last cell with data would be E20 it would use E20 in the formula for another cell. But if I add another row so the last cell with data is E21, that the formula would then use E21 instead of E20. Thanks!

[mike12]

Thanks a bunch, just what I needed!