Find The Highest or Lowest Value In A Row and Return the Column Headings

[YGY]

Hi, hoping to get help figuring this out.

• I have 5 categories, 5 columns for each category (A,B,C,D,E).
• I have a form (from the same table as 5 category columns table) with 42 Y/N questions. Each question scores a 1 if answered Y for the category it belongs to. I have this part working well, but don’t have to go with this method if there’s a better option.

What I’m try to achieve: After a user answers all 42 questions, I would like to know which three categories scored the highest and I then want to take that result to a filtered view based on the result (another table with a description of the 5 categories).

Thanks.