Collect items in multiselect cell from one cell if item was not used by second cell
I have a cell (multi-select type) with all possible items listed. I have another cell, that is also multi-select that uses some or all items from cell one. I need to collect all items from cell one that was not used in cell 2 in cell 3.
I feel that It should be somehow Join and collect minus what was used. Please see picture. Any suggestions?
Help Article Resources
Check out the Formula Handbook template!