Related Posts
This is why I secretly avoid 1:1s with my manager!

Additional Posts in Consulting
La Guardia terminal C pre-check can suck a dick.
Spread collar. Four in hand or full windsor?
It’s all I have time for

New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.




How efficient is the algo? How many passes through the list to obtain the matches?
FYI: function is essentially an index match that returns each unique match instead of one
I read in the ranges I am checking for a match, store the ranges in memory, then I loop through the entire range because the matches happen multiple times
Can you use a hash table to store the data?
Assuming you're using excel, have you considered whether access could help here?
@EY1 I'll look into it and see what the options are. @ey2 It's a huge workbook that I'm helping automate otherwise I'd definitely do the analysis in access