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.

--
sherbrooke

Something similar to this:
=RANK(V1,$V$1:$V$8,1)
placed into the first row of your column 23, and then copy down.
Adjust references to match your columns/rows.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"sherbrooke" wrote:

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.

--
sherbrooke

Try

=RANK(A1,$A$1:$A$8)

Change the range to suit the range you are ranking and drag down

Mike

"sherbrooke" wrote:

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.

--
sherbrooke