Hello. I have administered a test for my students where they answered many questions which then give scores to each of 8 areas of "intelligence." I use a formula, INDEX($CS3:$CZ$4,1,MATCH(LARGE(CS3:CZ3,1),$CS3:$CZ3,0)) to search the 8 values and select the largest and return the title of that intelligence which is in the column header, row3.
My problem, or one of them, is that some students have more than one area of intelligence tied for the highest score. As it stands, I onmly report the area which is the first that Excel finds on the left. I would like to have Excel return all the areas (column titles) for the columns that share the highest scores. If the high score is unique, I'd get the current result. If there is a tie, I'd get 2 results etc.
Vlookup, index and match are about as advanced as I get with Excel at the moment, but I'd love to learn how to solve this problem. The end goal is to help my entire school program better for our students, so it's a worthy cause.
Thanks,
Josh
Bookmarks