Looking for final four values in range, excluding any blank cells

My nomenclature may be a bit off for Excel, but I値l try to explain what I知 trying to do the best I can. I may over-explain everything, but bear with me.

End goal of what I知 trying to do: find the average of the lowest 3 values from the final 4 values in a row, excluding blank cells. I know how to use the AVG and MIN functions to create the average and find the lowest, second lowest, and third lowest values in a range, but I知 not sure how to create the four value range of the last four values (excluding blank cells).

My thoughts on how to do this: create a range (say, A2 through P2, A2:P2), then have a function systematically check each cell (starting with P2 and working backwards towards A2) to see if it has a value, then keep doing that until it has four values.

Attached is a screenshot of an example spreadsheet and a 2013 excel file with the example.

I appreciate any help you guys could offer me!

Thanks for the quick response, and for catching the stuff I hadn't thought of.

I need the intermediate columns to be present (the columns showing the 3 lowest of the last four), but I assume those would be very similar formulas except they'd end at the MIN function?

I would need the average to be the average of how ever many (of the three) present. For example, if there are only two values than it would be the average of the two. And, then, one of the three intermediate columns would be blank.

Thanks for all the help, everything worked perfectly.

I appreciate the help; I've been able to reverse-engineer what you did and have finished a handful of things I didn't know how to do before.

There is another thing I'm stuck on, though. It's very similar to what you already helped me with, but I think there will be an extra IF or two.

I have attached a screenshot and excel file describing what I'm trying to do (with an example highlighted in red). Basically, I'm trying to find the lowest four values in columns E through T (E:T, labelled 1 through 16), but if there aren't four values then it should include the lowest of column A through D (A:D, labelled L1 through L4) until there are four values. This may include using all four values from columns A:D, and if there isn't four values between A:T then the it should be left blank (including if there are no values whatsoever).

That worked perfectly. Thanks for all the help, I really appreciate it.