Shortest Formula Challenge

[Twifoo]

For those seeking to improve their formula skills, here are eight (8) formula challenges for you!

[#2]

Two weeks ago, I gave a clue in LinkedIn that two of the functions I used to solve the challenge were shockingly excluded from the results of the Pivot Table created by @Bill Jelen. By giving that same clue here, my challenge might ultimately incite your curiosity.

[#3 · Accepted solution]

@Twifoo My post to understand your brilliant formula:

 https://www.myspreadsheetlab.com/robert-gascons-shortest-formula-challenge/

It was extremely interesting to audit and understand! Thanks Robert.

Cheers,

Kevin

[#4]

@Kevin Lehrbass, 

You had an amazing analysis, as usual. Let me emphasize that I used MMULT to return the sum for each row or column, and FREQUENCY to return the maximum of the sums.

[#5]

For those who are wondering where the solution file is, I am attaching it here to satisfy your curiosity.

[#6]

@Twifoo 

Long back  this has had been posted y you on Facebook,,, and I've solved it using SUMPRODUCT,, did you remember ?

[#7]

@Rajesh_Sinha 

To the best of my knowledge and belief, nothing was ever proposed as a solution to my challenge. If you believe otherwise, kindly paste the link here to refresh my purportedly feeble memory. I honestly impugn the possibility of such a solution you claim to have propounded before.

[#8]

@Twifoo 

It was in one of the Facebook groups,, wish I could find, since I'm member of several groups there, but I found the Workbook in my backup folder, was solved using SUMPRODUCT.

Let me say this was the challenge thrown by Robert Gascon,, as I found through the link,, !!

[#9]

@Rajesh_Sinha 

Forget about the link. Perhaps, you could post your formula solution here so we may learn from it.