Hi
Any help is much appreciated, please.
I have a spreadsheet where I have 2 columns that have lists in them, I've enabled a VBA macro so that I can select multiple options from the drop down.
I've attached my spreadsheet, in column 'F' I will select all the information that has been provided. In column G I want to list all the items that weren't selected from the original list so that I can perform a gap analysis much easier. Is it possible to set a formula to do this?
please let me know if there's any further info you require to answer my question. All responses are much appreciated, thank you in advance.BG ACC track.xlsmBG ACC track.xlsm
Bookmarks