Thread: last value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kevcar40 kevcar40 is offline
external usenet poster
 
Posts: 78
Default last value

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