Hi
Please can you help me with the following query:
On sheet 1 I have a list of locations in column A. In Column B is the sales for the month and in column C, the Sales for the same month last year.
On Sheet 2, row 1, I would like to sum up the sales for the Top ten locations ( based on Column B in sheet 1) and also sum the corresponding last year sales ( column C in sheet 2).
On Row 2, I would like to do the same sum, but for locations 11 to 25.
On Row 3, I would like to do the same sum, but for the bottom 10 locations.
Note: The number of locations is not constant every day.
I would appreciate any help
Thank you
JVN
Please can you help me with the following query:
On sheet 1 I have a list of locations in column A. In Column B is the sales for the month and in column C, the Sales for the same month last year.
On Sheet 2, row 1, I would like to sum up the sales for the Top ten locations ( based on Column B in sheet 1) and also sum the corresponding last year sales ( column C in sheet 2).
On Row 2, I would like to do the same sum, but for locations 11 to 25.
On Row 3, I would like to do the same sum, but for the bottom 10 locations.
Note: The number of locations is not constant every day.
I would appreciate any help
Thank you
JVN