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