I am looking to see if anyone has a fast method for comparing two long/large multikey fields.
In current situation
FieldA - Multi-Key List of SN's - 31,961
FieldB - Multi-Key List of SN's - 14,281
FieldC - Multi-Key List of SN's from A, not in B.
I have tried the custom function ZapValues from Brian Dunning's website, and
I created a script that loops through the lists
(Script Image Attached)
both approaches result in the correct answer for FieldC, but come with a HUGE time expense.
Any ideas on a better (faster) method.