Forum Discussion
Twifoo
Sep 12, 2020Silver Contributor
Shortest Formula Challenge
For those seeking to improve their formula skills, here are eight (8) formula challenges for you!
- Oct 15, 2020
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
Kevin Lehrbass
Oct 15, 2020Brass Contributor
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
Twifoo
Oct 15, 2020Silver Contributor
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.
- TwifooDec 03, 2020Silver Contributor
For those who are wondering where the solution file is, I am attaching it here to satisfy your curiosity.