Forum Discussion
Excelnovice75
Sep 19, 2024Copper Contributor
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!
- m_tarlerSteel Contributor
try:
=UNIQUE(VSTACK( A1:A100, B1:B100 ), , 1)