Forum Discussion
Finding the MIN in a row, and then also the cell 2 spots to the LEFT of the MIN cell.
I'm trying to make my formula work to find the lowest price in a ROW of data. I've sorted out to use the MIN function - no problem. The issue now is that I need to also figure a formula to give me ...
=INDEX(C2:K2, MATCH(MIN(C2:K2), C2:K2, 0)-2)You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
=INDEX(C2:K2, MATCH(MIN(C2:K2), C2:K2, 0)-2)You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
OliverScheurich This works!! Looks like I was using the wrong range and also using -1 instead of -2. Thank you so very much!!
