Hello,

I can't find the formula in Excel.

I have a column with three digits: 5, 1, 4.

And two cells for the result; the first cell should show the largest digit (5), the second cell the second largest (4);

Knowing that the input can be 1, 5, 4 or even 4, 5, 1.

I would like the largest digit to appear in cell 1 (e.g., 5) and the second in cell 2 (e.g., 4).

Thanks in advance for your responses