Getting the highest value out of a chart

I have a 3x3 table in excel with investors on the vertical axis and companies on the horizontal axis (please see attachment). The investor will rate each company from 1 to 5. 1 being the best and 5 being the worst. So, the company with the lowest points wins. What formula would I use that would output the name of the winning company? I am really confused and would appreciate the hellp! This is a simplifed example the real data set has 100's of data points.

Company 1 Company 2 Company 3
Investor 1 1 2 3
Investor 2 2 3 1
Investor 3 1 3 2

Total: 4 8 6

Originally Posted by CK76

Something like below?

=INDEX(C6:G6,,MATCH(MIN(C12:G12),C12:G12,0))

Or am I missing something here?

Thank you

Originally Posted by mehmetcik

Formula:

Please Login or Register  to view this content.

Thank you very much for your help

Also, do you know what the formula would be to pick the top five companies? (i.e the 5 companies with the lowest scores)

This will return the companies in order from lowest to highest scores:

=INDEX(C$6:G$6,MATCH(SMALL(C$12:G$12,ROWS(A$1:A1)),C$12:G$12,0))
Dragged down

Note that this will have to be tweaked if there are ties.

Thank you for your help. I will play around with it! I really appreciate it

Glad we could help. Thanks for the rep!

If that solved your question, please mark this thread as SOLVED.