Try this and copy across
Wow! Nflsales you are a GUN. I cant believe a formula was able stack them in a List I'm stunned. thankyou so much!


May I trouble you for one small thing i just thought of (got excited after this list thing is suddenly a reality!) In the Team sheet you gave me the formula for, I was also hoping under each day (where you'll see "Not rostered but available") to be able to pull everyone who had an X or a R/O for that day into a list below? So basically on top are the teams for the day and at the end are people had an X or R/O for the day as "backup spares".

thanks so much again!