Forum Discussion

Dam_Tran's avatar
Dam_Tran
Copper Contributor
Aug 30, 2023
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, 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

Resources