Hi,

You can use another mthod for that which is an array formula

=ADDRESS(MAX(IF(LEN(A1:A1000)0,ROW(A1:A1000),0)), 2)

This is an array formula which must be entered by pressing CTRL+Shift+Enter
'and not just Enter. If you do it correctly then Excel will put curly brackets
'around the formula {}. You can't type these yourself. If you edit the formula
'you must enter it again with CTRL+Shift+Enter.

Mike

"kevcar40" wrote:

On 4 Sep, 10:26, kevcar40 wrote:
On 4 Sep, 09:22, Mike H wrote:





Hi,

Try this

=LOOKUP(2,1/(A1:A52<""),A1:A52)

Mike

"kevcar40" wrote:
hi
i ahave a worksheet that the user enters a score for each week
wk 1 =a5.............wk 52 = a57
what i want to do is chack the range (a5:a57) and find the last entry
so if wk33 has a value of 1500 entered and wk34 has a value of 2000
entered
i want to return 2000

how do i go about finding last value

thanks

kevin- Hide quoted text -

- Show quoted text -

thanks mike works a treat- Hide quoted text -

- Show quoted text -

is it posible to return the cell address using this formula