Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
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 |