This is probably a stupid question but here it goes.... I want to find the last 5 values (non blank cells) that are set across a single row with 20 columns. And as I add more data it needs to continue to show the latest last 5 values.
I have the formula (below) to locate the last value in the set but for some reason I've gone brain dead on how to retrieve the last 4 behind it

Here's an example of what I got in the row thus far and what I'm looking for. "BC"= a blank cell
55 54 BC 63 53 BC BC 55 54 BC 53 BC 57 59
I used this generic formula =LOOKUP(2,1/(A2:T2<>""),A2:T2) to find the last value 59. I just can't figure out how to retrieve the other last 4 #'s (57,53,54,55) and so on as the list grows. And Yes, there will continue to be blank cells mixed in between the numbers.

I would greatly appreciate any assistance that is given! THANK YOU in advance!