Roster: Listing staff names per shift plus total - file attached

Hi everyone,

I am quite new in exploring the power of Excel but quite enthusiastic about it's
possibilities.

My problem is that I have one large Excel table with staff names, dates and
shifts they are working. I only need to list Morning, Evening and Night shifts.
Also I should be able to list cells that has like M* or anything added after
capital letters for shifts (M,E,N)

I would like to be able to create a list/report for each shift separately of all
staff names that work in that shift, preferably with numbers (1,2,3.....)
next to their names.

Also total number of staff should be calculated and displayed on that report
or picked up from already made formula at the bottom of that Excel table.

Thank you all for your inputs.

E.

I realised that I am supposed to put the outcome or
a how I would like that report to look like.
So here it is:

Morning shift:

1. AA
2. BB
3. D
4. Y
5. S
6. B
7. O
8. R
9. I
10. T


Evening shift:

1. H
2. CC
3.
4.
5.
6.
7.
8.
9.

Night shift:

1. L
2. P
3. W
4.
5.


Please let me know if I need to provide any other info.
Thanks.

E.

Hi,

Thank you for reply.

What I want is to create a list of staff (their names) per each shift,
from my table. is that possible?
Also it would be great if their names can be in separate cells.
Hope this helps to understand better but please ask if you need
more information.
Thanks.

E.