S
sherbrooke
Can anyone please suggest a formula to meet the following requirements.
I have 8 rows of differing numbers over 21 columns, I total them in
column 22,
I would like a formula to go in each of the 8 rows in column 23 which
allocates a number from 1 to 8 depending on the total in column 22, 8
going to the row with the highest figure and 1 to the total with the
lowest figure.
I have 8 rows of differing numbers over 21 columns, I total them in
column 22,
I would like a formula to go in each of the 8 rows in column 23 which
allocates a number from 1 to 8 depending on the total in column 22, 8
going to the row with the highest figure and 1 to the total with the
lowest figure.