Hi, I've searched around and found some VBAs for this , but could not get them to work. I'm pretty new to VBA , so perhaps I was installing the VBA wrong. Sample xlsm file attached. In real life application, I'll need to run this for 40,000+ rows. Sample contains about 40 rows. I use Excel for Mac. Any help would be much appreciated . much thanks
_Compare 2 Columns - Show differences in Columns C and D.xlsm
Bookmarks