To to your channel. Hello there. I really enjoyed last year's Excel Hash and the 4 videos I have watched so far. Somehow I managed to create a number guessing game on a TI-83 back in high school. This brings back memories. Great stuff. I can see how this can be modified with LET and LAMBDA to expand the range. The possibilities are endless. My TI-83 program allowed the user to change the range (i.e. 1-100, 1-1000, etc), and the max number of guesses (i.e. 5, 10, 2), and gave the user different messages based how fast they solved it (or didn't). THis solution gives me ideas to try my own number guessing game. Thanks for the inspiration.
@@chandoo_ sure thing. I’ll work on it tonight. I’ll also share my searchable dynamic drop down list once I have updated to include something’s I got in feedback from cr gr0912. You might have seen him in the comments
If D4 was 'Even' or 'Odd' (or Yes or No), then simper answer go get array is: =FILTER(E2#,IF(D4="Even",MOD(E2#,2)=0,MOD(E2#,2)=1)) Here E2 has sequence function (assumption) this is simple alternative I believe.
Hello teacher 👨🏫 I have a question for you, when I do Bank reconcile , there is only one acct name . But multiple debit and credit amounts. some time you have to try so many times and add them together to eliminate them. Is there a formula to do it quickly? I try to use the formula you teach us several years ago, but it won’t work with my Scenario, please advise thank you so much!
try fitting this method in kalyan Matka Chart..its a challenge
I was actually thinking about it and😅 saw your comment
HOLY MOLY!! Shao is really smart!
I like this game/solution and highlighting of the binary search function.
Thank you so much for playing ExcelHash.
Super happy to be part of this Oz. I really enjoyed making the game.
Very cool HASH Guessing Game Dashboard, Chandoo!!!!!
Thanks Mike ... :)
To to your channel. Hello there. I really enjoyed last year's Excel Hash and the 4 videos I have watched so far. Somehow I managed to create a number guessing game on a TI-83 back in high school. This brings back memories. Great stuff. I can see how this can be modified with LET and LAMBDA to expand the range. The possibilities are endless. My TI-83 program allowed the user to change the range (i.e. 1-100, 1-1000, etc), and the max number of guesses (i.e. 5, 10, 2), and gave the user different messages based how fast they solved it (or didn't).
THis solution gives me ideas to try my own number guessing game. Thanks for the inspiration.
Thanks Patrick. That is awesome to hear how you can use LAMBDA to make it dynamic. Do share the formula with us once you implement it.
@@chandoo_ sure thing. I’ll work on it tonight. I’ll also share my searchable dynamic drop down list once I have updated to include something’s I got in feedback from cr gr0912. You might have seen him in the comments
Nice idea. I like the trick to display random picture 😀
Glad you like it!
If D4 was 'Even' or 'Odd' (or Yes or No), then simper answer go get array is:
=FILTER(E2#,IF(D4="Even",MOD(E2#,2)=0,MOD(E2#,2)=1))
Here E2 has sequence function (assumption)
this is simple alternative I believe.
I agree but it was compulsory to use the EVEN function. We all struggle to use this function in our solution.
Yes, the cunning Oz master wanted us to use EVEN() function.
@chandoo, My office not support the templete you are uploaded, I am using (Microsoft Office Professional 2019)
Hello teacher 👨🏫 I have a question for you, when I do Bank reconcile , there is only one acct name . But multiple debit and credit amounts. some time you have to try so many times and add them together to eliminate them. Is there a formula to do it quickly? I try to use the formula you teach us several years ago, but it won’t work with my Scenario, please advise thank you so much!
SUPER COOL !!!
Thanks Faraz... :)
Cute Shao is Brilliant 😀
The best!
Amazing
Good
Kbhi Hindi me v bana liya kro