Thank you Luke M for the prompt reply! And thanks for the links which I will look at in more detail.
That is how I have currently started the spreadsheet but I am finding it difficult to work out how to rank the staff each week based on their figures. Or do I have to manually filter the table...
Hi, I was wondering if anyone could help me with the following scenario and let me know if it can be done in excel.
My scenario is this:
11 different shops
2-3 staff per shop (and not always the same staff at each shop)
Currently recording the number of orders each staff member takes and...