Dear All
I am not sure if this is possible but I know that if it can be done then the gurus here will know how.
I have data including a heading in cells B3:H73 but this will extend. However, the final two columns will be headed "YTD Position" and "This Month".
I would like a ranking value in each one but do not want to actually sort the data.
The "YTD" Position comes from ranking the numerical value in the column headed "YTD" and the "This Month" value comes from ranking the column to the immediate left of the "YTD" column.
If any of the values are identical then the column headed "City" should be used as a tie break to put it in Alpha order.
I hope that I haven't made this sound more confusing than it really is.
As always many thanks to those who have a look.
Lapta301
I am not sure if this is possible but I know that if it can be done then the gurus here will know how.
I have data including a heading in cells B3:H73 but this will extend. However, the final two columns will be headed "YTD Position" and "This Month".
I would like a ranking value in each one but do not want to actually sort the data.
The "YTD" Position comes from ranking the numerical value in the column headed "YTD" and the "This Month" value comes from ranking the column to the immediate left of the "YTD" column.
If any of the values are identical then the column headed "City" should be used as a tie break to put it in Alpha order.
I hope that I haven't made this sound more confusing than it really is.
As always many thanks to those who have a look.
Lapta301