SOLVED

Shortest Formula Challenge

%3CLINGO-SUB%20id%3D%22lingo-sub-1745507%22%20slang%3D%22en-US%22%3ERe%3A%20Shortest%20Formula%20Challenge%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1745507%22%20slang%3D%22en-US%22%3E%3CP%3ETwo%20weeks%20ago%2C%20I%20gave%20a%20clue%20in%20%3CA%20title%3D%22Clue%20to%20Shortest%20Formula%20Challenge%22%20href%3D%22https%3A%2F%2Fwww.linkedin.com%2Ffeed%2Fupdate%2Furn%3Ali%3Aactivity%3A6710556950544949248%3FcommentUrn%3Durn%253Ali%253Acomment%253A%2528activity%253A6710556950544949248%252C6712386269571375104%2529%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3ELinkedIn%3C%2FA%3E%20that%20two%20of%20the%20functions%20I%20used%20to%20solve%20the%20challenge%20were%20shockingly%20excluded%20from%20the%20%3CA%20title%3D%22Results%20from%20Pivot%20Table%22%20href%3D%22https%3A%2F%2Fwww.vertex42.com%2Fblog%2Fhelp%2Fexcel-help%2Ffavorite-excel-functions.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Eresults%3C%2FA%3E%20of%20the%20Pivot%20Table%20created%20by%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F10858%22%20target%3D%22_blank%22%3E%40Bill%20Jelen%3C%2FA%3E.%20By%20giving%20that%20same%20clue%20here%2C%20my%20challenge%20might%20ultimately%20incite%20your%20curiosity.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1782003%22%20slang%3D%22en-US%22%3ERe%3A%20Shortest%20Formula%20Challenge%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1782003%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3BMy%20post%20to%20understand%20your%20brilliant%20formula%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.myspreadsheetlab.com%2Frobert-gascons-shortest-formula-challenge%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.myspreadsheetlab.com%2Frobert-gascons-shortest-formula-challenge%2F%3C%2FA%3E%3C%2FP%3E%3CP%3EIt%20was%20extremely%20interesting%20to%20audit%20and%20understand!%20Thanks%20Robert.%3C%2FP%3E%3CP%3ECheers%2C%3C%2FP%3E%3CP%3EKevin%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1951892%22%20slang%3D%22en-US%22%3ERe%3A%20Shortest%20Formula%20Challenge%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1951892%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELong%20back%26nbsp%3B%20this%20has%20had%20been%20posted%20y%20you%20on%20Facebook%2C%2C%2C%20and%20I've%20solved%20it%20using%20SUMPRODUCT%2C%2C%20did%20you%20remember%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1660217%22%20slang%3D%22en-US%22%3EShortest%20Formula%20Challenge%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1660217%22%20slang%3D%22en-US%22%3E%3CP%3EFor%20those%20seeking%20to%20improve%20their%20formula%20skills%2C%20here%20are%20eight%20(8)%20formula%20challenges%20for%20you!%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Shortest%20Formula%20Challenge.PNG%22%20style%3D%22width%3A%20683px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F217955i526CA17FB727896C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Shortest%20Formula%20Challenge.PNG%22%20alt%3D%22Shortest%20Formula%20Challenge.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1660217%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Trusted Contributor

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

Shortest Formula Challenge.PNG

8 Replies

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

@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

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.

@Twifoo 

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

@Rajesh-S 

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.

@Twifoo 

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

@Rajesh-S 

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