You're on the right path, just a coupla steps to go.
One could be using RANK() instead of INDEX() to simplify a logic a bit.
Other things are just plain Table Calc filtering and setting Stack Marks to OFF.
Please find the attached wb make from a Sample Superstore.
Hope it could help.
AVG_4_Lowest_Profit_YF.twbx 1.2 MB
Yuri, thank you so much! I was starting to think there was no way to do it. I appreciate your willingness to help!
John, you're welcome.