Quick compare of two excel columns
Posted on 2003-02-25
I have two columns in excel. Column one is roughly 2500 rows and column two is roughly 10,000 rows. Column two is sorted in alphabetical order.
I am looking for the quickest way to compare the data in column one and see if it is in column two.
Would it matter if column one was also sorted?
Of course, I could just start at the top of column two and go down each time, but that takes way too long.
I would REALLY like to do this recursively if possible, but it has been quite a while since I have done that and would need some good code to look at.
I don't think this is HARD, but because of time limitations, I will reward alot of points for fast code, easy to understand and comes back here quickly. And if allowed, bonus points if its recursive and enough explanation for an old programmer to follow it quickly.
Thanks you guys!