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 possi...
m_tarler
Sep 19, 2024Bronze Contributor
try:
=UNIQUE(VSTACK( A1:A100, B1:B100 ), , 1)