I think that the best way to describe what I want is with a image
Check the image. Each row will have a description (Of a feature of the programming language, for example) each language will have a rate. The languages with the biggest rates will have their names shown in the "Winner" column.
I want the formula to use in the C column. It have to respect 2 things:
- I can add more languages (More columns)
- I can add more descriptions (More rows)
The best I could formulate was this:
=FILTER(C1,C2=max(C2:2))That will, in the first row, return only Ruby if Ruby has the max value. I couldn't make it generic to repeat for every column.
=FILTER(C1:Z1,C2:Z2=max(C2:Z2))Based on the above but it returns an error