Hello Everyone.
There are two columns of inventory numbers. Column A has items that need to be destroyed. Column B has items that have been destroyed.
I want to clean up Column A by removing all the inventory numbers that are in Column B. In other words, if the inventory number exists in Column B, it must be removed from Column A.
Is there a function or combination of functions that will accomplish this? It would be awesome if it could be a dynamic function.
I tried using Filter and Filter with If, but I am just not skilled enough to figure it out.
Bookmarks