Forum Discussion
Solved
Find 2nd smallest number in a row but values not next to each other
Dear everyone, I'm looking for help in formula which can help find 2nd smallest number in a row, but values to find are not next to each other. Example: I have values in cell A1, A5, A8, A12, A50, a...
=SMALL((A1,A5,A8,A12,A50),2)
=SMALL((A1,A5,A8,A12,A50),2)
Detlef_Lewin thank you so much!!!!! super simple but works well. Thank you.