Addition of columns with all combinations

[steffin]

I have lets say 20 columns with a list of 50 numbers in each column. I am trying to get the largest sum possible, by adding 2 columns with all the possible combinations.
How do I achieve that?

I am attaching a mini version of excel screenshot of what I want to achieve.

 

[Legacy 143009]

Something like this?

=ADDRESS(ROW(),MATCH(LARGE($B1:$I1,COLUMN(A1)),$B1:$I1,0))&"+"&ADDRESS(ROW(),MATCH(LARGE($B1:$I1,COLUMN(A1)+1),$B1:$I1,0))

 

[steffin]

Something like this?

=ADDRESS(ROW(),MATCH(LARGE($B1:$I1,COLUMN(A1)),$B1:$I1,0))&"+"&ADDRESS(ROW(),MATCH(LARGE($B1:$I1,COLUMN(A1)+1),$B1:$I1,0))

I tried this code, but couldn't make it work. I am not an expert. Attaching the sheet screenshot here, for better understanding.

 

[Legacy 143009]

This will give you possible largest sum combinations. Try paste this formula to P3 and drag to right

=LARGE($B3:$N3,COLUMN(A1))+LARGE($B3:$N3,COLUMN(A1)+1)

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Addition of columns with all combinations
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.