Referencing the closest filled in cell

  • Thread starter Thread starter Taylor
  • Start date Start date
T

Taylor

I've created a spreadsheet in which each row represents one day and the last
row is the total for the month. I need to have one of the month total cells
take the value of the most recent filled in cell. So if my spreadsheet is
set up like the below example, I want the column next to M (month) to pull
the value from lowest filled in cell. There will be blanks between the total
and the most recently updated day.

1 150
2 148
3 145
4 142
5
6
....
31
M 142

Any help would be appreciated.

Thanks,

Taylor
 
Try:

=LOOKUP(100^100,A1:A31)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Thanks, Sandy.

-Taylor

Sandy Mann said:
Try:

=LOOKUP(100^100,A1:A31)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
Click to expand...
 
You are very welcome. Glad that it worked for you.

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top