View Single Post
  #1   Report Post  
hungryman
 
Posts: n/a
Default Function to return the latest non-zero value in a range of cells .

I have a list of dates witten sequentially in a row on the sheet. Under some
of these I have some values. I need to find the non-blank value associated
with the latest date. Is there an easy way of doing this?