So I have a column that that has up to 18 values in it, I would like to take the highest value from that set of 18 cells and have it display in another cell, then the next higest value from the 18 cells in another cell and so on up to five values. How should I go about doing this? Below is a crude example of what I am trying to accomplish.
10_________ 50
20_________ 40
30_________ 30
50
10
10
40
10
10
10
10
10
10
19
18
15
Bookmarks