In my table I have in column A, students' first choice in major when they apply, and in column B, the degree they eventually earn. In column C I have the percentage of students that end up following that pathway. Based on the percentage in column C, I only want to display the top 3 degrees for each major listed in column A.
My table has 6K+ rows; how can I do this when each major in column A has varying numbers of degrees in column B? Macro? Something I don't know about with pivot tables?
table.png
Bookmarks