Function to choose most recent (southern) value

[RJB78]

Hello - I have a worksheet that I input values each week. I would like a formula that gives me the most recent input. In the example below, 17% would be the result because it was the 'most recent' entry. Thank you in advance

Week 1	25%​
Week 2	10%​
Week 3	30%​
Week 4	17%​
Week 5
Most Recent Entry	=MOST Recent

 

[Stephen_IV]

=LOOKUP(REPT("z",90),B1:B5)

 

[RJB78]

=LOOKUP(REPT("z",90),B1:B5)

Receiving #NA from this. Could you explain the formula components further?

 

[Fluff]

What version of Excel are you using?
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[RJB78]

What version of Excel are you using?
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

365, thank you. I have made the profile update

 

[Stephen_IV]

=LOOKUP(9.99999999999999E+307,SEARCH("?*",B1:B5),B1:B5)

 

[Fluff]

Thanks for that, how about

Fluff.xlsm
	A	B
1
2	Week 1	25%
3	Week 2	10%
4	Week 3	30%
5	Week 4	17%
6	Week 5
7	Most Recent Entry	17%
Data

Cell Formulas
Range	Formula
B7	B7	=TAKE(FILTER(B2:B6,B2:B6<>""),-1)

 

[RJB78]

Thanks for that, how about

Fluff.xlsm
	A	B
1
2	Week 1	25%
3	Week 2	10%
4	Week 3	30%
5	Week 4	17%
6	Week 5
7	Most Recent Entry	17%
Data

Cell Formulas
Range	Formula
B7	B7	=TAKE(FILTER(B2:B6,B2:B6<>""),-1)

Thank you, what is the solution if it was excel 2016?

 

[Fluff]

How about

=LOOKUP(2,1/(B2:B6<>""),B2:B6)