|I am trying to do a ranking from first place to last place in 3 different colums.|
My colum answers are in colum G K and O
Colum G Row 3 has an answer of 151 and is the highest so far giving answer of 1 and then the rest go down to 2 or 3 etc.
when i get to colum k row 15 and i enter 201 then it becomes highest and answer becomes number 1
moving the g3 answer down to 2.
EG IN TABLE
G K 0
100 175 95
201 68 151
in this example the ranking of 201 would be first. then down to 175 in second then down to 151 in third. and so on.