I want to be able to rank stores sales growth by region.
I have a sheet that has 4 columns of data
Column A contains numbers from 1 to (number of stores in that region)
Column B contains the store number
Column C contains the rank for the store within the region based on the store growth
Column D contains the store growth
Each region is repeated under the other region down the sheet.
The problem is that if a new store is inserted it will usually be at the end of the region as the store number will be higher. This then throws out the ranking as they do not take into account for the new store. Also a store could close and be deleted and once again if it is at the end of the rank it creates an error. Also the regions are in units of 5 starting at 10. ie 10,15,20,25 etc etc. Regions 10 & 15 are ranked togather as are 20 & 25 etc.
How can I get it to change the ranges based on the change in the number of stores within the regions?
Thanks,
Alan.
I have a sheet that has 4 columns of data
Column A contains numbers from 1 to (number of stores in that region)
Column B contains the store number
Column C contains the rank for the store within the region based on the store growth
Column D contains the store growth
Each region is repeated under the other region down the sheet.
The problem is that if a new store is inserted it will usually be at the end of the region as the store number will be higher. This then throws out the ranking as they do not take into account for the new store. Also a store could close and be deleted and once again if it is at the end of the rank it creates an error. Also the regions are in units of 5 starting at 10. ie 10,15,20,25 etc etc. Regions 10 & 15 are ranked togather as are 20 & 25 etc.
How can I get it to change the ranges based on the change in the number of stores within the regions?
Thanks,
Alan.