In Google Sheets, I have numbers in 12 cells in a row. Then in the 13th cell of the same row, I have a number which is one of these 12 numbers. Now, I want find the 1st value lower than the value in the 13th cell going from right to left. Example:
2020 2090 2201 2393 2273 2159 2105 2200 2150 2199 2225 2290 2159
2159 is 13th cell value, which is in the 6th cell and the 1st lower value before that is 2090. I want this value in a cell in that row. The 13th cell value can be any of the 1st 12 cell values (not necessarily in 6th cell).
=MINIFS()
?