I'm trying to rank a group of 5 cells and assign a value to them. For example Cells B26:B30 I would like to assign the values as follows in Cells C26:C30.
Numbers in Column B must stay in their current cell.
Lowest Number from Column B receives a 10 in Column C
Next lowest in B gets 7 in C
5 in C
3 in C
1 in C
Is this possible?
Thanks in advance.
Numbers in Column B must stay in their current cell.
Lowest Number from Column B receives a 10 in Column C
Next lowest in B gets 7 in C
5 in C
3 in C
1 in C
Is this possible?
Thanks in advance.