Ask HN: Can anybody help me with sorting this data?

Hey I have this excel file, it containts 37 or so columns and each column contains list of mustcourses for that department. can u help me get 1-list of pairs of departments that have largest number of shared courses, 2-ability to list of shared courses of one department compared to all of the rest, 3-courses that are shared the most among departments. p.s. there has to be ignore list where i can add and remove courses to be ignored in calculations. I can send you the excel file for you to take a look before you say you can help.