Forum Discussion
Shortest Formula Challenge
For those seeking to improve their formula skills, here are eight (8) formula challenges for you!
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
8 Replies
Long back this has had been posted y you on Facebook,,, and I've solved it using SUMPRODUCT,, did you remember ?
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.
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,, !!
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
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.
For those who are wondering where the solution file is, I am attaching it here to satisfy your curiosity.
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.
