Forum Discussion

Excelnovice75's avatar
Excelnovice75
Copper Contributor
Sep 19, 2024

Showing remaining options on a list

Hoping that someone might be able to help answer a question about lists in Excel. I'm trying to find a way of listing the remaining options not selected from a list and was wondering if this is possible to do. For instance, in devising a rota where two people out of a group of 6 need to work each week and are listed in column A and B respectively, is there a way of listing those not working (i.e. the remaining 4 who would be on reserve) in column C? Any advice or suggestions would be much appreciated!

Resources