Have difficulty to find 2nd max, 3rd max value in 1 column etc
Hi JSL experts, I have a big trouble to find the 2nd max, 3rd max etc value in 1 column.For a col below, I hope to identify the top 5 max value, and mark the value out in a sperate column.It seems I can only find the col max, but have a lot of difficulty to find the 2nd max, 3rd max etc.Is there any standard formula for this solution?
Thanks (100,232,343,121,100,132,100,100,100,100,)