User Profile
Excelnovice75
Copper Contributor
Joined 4 months ago
User Widgets
Recent Discussions
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!229Views1like1Comment
Groups
Recent Blog Articles
No content to show