You are viewing a single comment's thread from:

RE: Excel Formula Fun

in Excel For All4 years ago

Would you believe coming up in my publishing schedule is matching two lists in Excel

use Power Query, load both columns as separate tables, then do a merge, join type all from the first not in the second. This will return you with a list of items in H that are not in I. It doesn't matter how much data you have, power query can handle it better than Excel

Or the match function Picture35.png

I think as you did not lock in cell references using $,so when you dragged your formula, it broke.