That is most impressive! A few questions, forgive me:
Does this code assume that each Unique ID is represented in both sets of data?
Also, if I were to replace one of the columns with text, will that affect the functionality? I assume if I wanted to add columns to the data sets, I would just add another:
And then adjust the following to account for the new column:
Lastly, is there a limit to the amount of rows this will search and match? I assume row counts approaching or exceeding 1000 would take a long time to calculate?
Thanks again JBeaucaire!
Bookmarks