I have a spreadsheet in which ratings have been given for various categories. I need a formula to show which categories have the highest rating for each row. I have found a formula for when categories are listed in a single column and the ratings in the next column. But the layout of my spreadsheet requires the categories to be listed in the same row, and the ratings in the row/s below. I have attached an example to insert formula in. Hope you can help.
----
Revised attachment added
Bookmarks