Comparing Columns of no particular order
Posted by Tim on February 11, 2002 9:05 AM
I have two sheets (A and B), with a similar but not identical column in both (namely file names). I need to know which file names are present in both sheets, and produce a list of those files (with all the associated data on both sheets) and simialr lists for those that are not repeated.
I KNOW this must be a relativly simply proceedure in Excel, but I have resorted to comparing them all by hand, which is really starting to numb my brain!
Thanks for any help you can give,