If I wanted to rank a set of values in different cells, all in the same column or all in the row from lowest to highest, without sorting, how would I do that? . e.g. Cell A2=14.3, A3=5.6, A4=8.9, A5=11.3, and A6=2.4 How could I put a ranking in column B to show that Cell A6 ranked 1st, A3 2nd, etc...?
Solved by E. S. in 21 mins