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