I've been looking for a good way to compare inventories. I've got data in col A&B, which should match. But i've been looking for a way to compare both columns and get the output in Columns C&D.
So I'd like to find a way to get the following:
Column C = What's NOT in ColB, but IS in ColA
Column D = What's NOT in ColA, but IS in ColB
Does anyone have an idea what's the best&easiest way to get something like this? I'm assuming using macros, but i'm not a big expert at that .. Or does anyone have something similar or can put me in the right direction?
Thanks !
Bookmarks