Find largest total when multiplying x and y

[ollyhughes1982]

Hi,

I am looking to calculate something in a formula that is pretty easy by looking at a visual representation, as per the image below:

What I want to do is find the largest rectangle / square total (at least 2 values for both x and y). However, I am struggling. This is easy from the visual as I can just do a visual and use a process of elimination to find the largest area.

I have found that my result is 30. i.e. I have done 2 events 15 times each (2x15 at Newport and Riverfront), which is greater than all of the other combinations:
6x3 (=18)
3x6 (=18)
2x8 (=16).

I am just trying to figure out how I could do this in a formula, please?

I have attached an image (below) of the original post in a facebook group about parkrun challenges, which gives the initial explanation:

Link to file (small and opens quickly): Largest x x y.xlsx

Thanks in advance!

Olly.

 

[Fluff]

How about

=LET(f,SORT(FILTER(B4#,B4#>1),,-1),r,ROWS(f),MAX(INDEX(f*SEQUENCE(r),SEQUENCE(r-1,,2))))

 

[ollyhughes1982]

How about

=LET(f,SORT(FILTER(B4#,B4#>1),,-1),r,ROWS(f),MAX(INDEX(f*SEQUENCE(r),SEQUENCE(r-1,,2))))

That works perfectly. Thanks so much. You truly are an Excel genius!

 

[Fluff]

Glad to help & thanks for the feedback.