Forum Discussion
Dam_Tran
Aug 30, 2023Copper Contributor
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, and would like to see which value is the 2nd smallest one. Could you please help with any formula? Thanks in advance.
Best regards,
Dam
=SMALL((A1,A5,A8,A12,A50),2)
2 Replies
- Detlef_LewinSilver Contributor
=SMALL((A1,A5,A8,A12,A50),2)
- Dam_TranCopper Contributor
Detlef_Lewin thank you so much!!!!! super simple but works well. Thank you.