Find character in last filled cell

[JTL9161]

I have a row of cells.

C5:T5.

Each week a number will be entered into starting with C5. Then the next week in D5 and so on.

Looking for a formula that will always return the most recent number entered. Meaning if I put a 3 in C5 and then a 6 in D5, I am looking to grab the 6 in D5. Then next week when a a 7 is entered in E5 i need to grab the 7 and so on.

Thank you,
James

 

[Fluff]

How about

=TAKE(FILTER(C5:T5,C5:T5<>"",""),,-1)

 

[JTL9161]

Perfect. as always

Thanks

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Scott Huish]

Also:
=LOOKUP(10^100,C5:Z5)