SOLVED

# Shortest Formula Challenge

Trusted Contributor

# Shortest Formula Challenge

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

8 Replies

# Re: Shortest Formula Challenge

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.

Best Response confirmed by Twifoo (Trusted Contributor)
Solution

# Re: Shortest Formula Challenge

@Twifoo My post to understand your brilliant formula:

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

Cheers,

Kevin

# Re: Shortest Formula Challenge

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.

# Re: Shortest Formula Challenge

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

# Re: Shortest Formula Challenge

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

# Re: Shortest Formula Challenge

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.

# Re: Shortest Formula Challenge

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,, !!

# Re: Shortest Formula Challenge

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