Find corresponding combination with the maximum value.

Hello, I am a structural engineering major and need help with a potentially simple solution but it has stumped me for hours. In my file, you will see my calculation sheet and the 2 maximum combination cells I need help with. I set up a MAX command to find the greatest value of the combinations but below the value, I need it to also say the combination number is also. For example, the max loads in the file are 56.4 and below that would automatically say "combination 3" and the second max value is 42.5 and below that would be combination 3 (random chance they are the same). So hopefully, with your help, you can figure out a function that will say the corresponding combination with the maximum value.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

As you are new here I did it for you this time.Please read forum rules