• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Amazing Techniques from LinkedIn Excelhero forum

N

NARAYANK991

Excel Ninja
Hi All ,


I recommend that everyone go through this amazing challenge ; it was posted in the above forum 10 days ago , and no one could come up with an answer !


The challenge and the solution with a detailed explanation are here :


https://sites.google.com/site/e90e50fx/home/excel-challenge-find-the-pattern


Narayan
 
Hi Narayan,

Thanks for sharing that link. Those are incredibly amazing formulas / techniques!


While I liked the one with MMULT also, I was simply amazed by the the FREQUENCY based one. I wonder how Kris detected that pattern, and the need for that specific marker-matrix. (I am still relishing that formula in my mind!!)


Thanks again for sharing!


-Sajan.
 
You must log in or register to reply here.
Back
Top