I have an excel spreadsheet that I need to compare two columns of text to find values that match then populate another column with the results.
My first column (A) has 94,000 rows of data. I have to compare that to my second column (J) that has about 30,000 rows. For values that match I have to populate another column (B) with a "yes" if there is a match.
Is there a macro that can do this for me?