Last Number in Column

P

paulrm906

Hello everyone

I am currently using the formula =LOOKUP(9.99999999999999E+307,A:A) t
find the last number in a colmn (The above formula was thanks fro
Aladin) But unfortuneately it will not work if there are formulas i
the column. does anyone know how to solve this problem as I really d
need to keep this formula in that column.

Thankyou

Paul Maynard
Moscow
 
P

paulrm906

Thanks Gary's Student

It works great and the link as many useful formulas also

Thankyou

Paul Maynard
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup last in column formulas 6
Question on index 3
search a column for last instance of text 2
Searching up a column 7
Locate last cell in column 8
Last Number in Column 2
2nd and 3rd last number in a column - how to get it? 4
Last Value in a Column when Value <> 0 1

Top