I have two excel sheets both containing huge set of data of colleges names in different formats and abbreviations. I want to find the list of colleges common in both the sheets, however because of inconsistency in format names of colleges it is proving to be very tedious and difficult to do so. kindly suggest the best effective method to do the work.
Is there any way to do so in excel with the help of some other tool or maybe some in-build tools in excel. I have already used filters like sort, find and replace filters etc.
submitted by /u/Darkness-of-Light
[link] [comments]
