Sep 11 2020 11:50 PM - edited Sep 12 2020 12:11 AM
For those seeking to improve their formula skills, here are eight (8) formula challenges for you!
Oct 05 2020 06:31 AM
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.
Oct 14 2020 08:25 PM
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
Oct 14 2020 09:33 PM
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.
Dec 02 2020 06:16 PM
For those who are wondering where the solution file is, I am attaching it here to satisfy your curiosity.
Dec 03 2020 02:56 AM
Long back this has had been posted y you on Facebook,,, and I've solved it using SUMPRODUCT,, did you remember ?
Dec 03 2020 03:25 AM
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.
Dec 04 2020 03:16 AM
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,, !!
Dec 04 2020 07:52 AM
Forget about the link. Perhaps, you could post your formula solution here so we may learn from it.
Oct 14 2020 08:25 PM
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