Awesome clear and concise explanation. Gold. I believe you said row when referring to a column? Well that’s how it works in a database. Apologies if excel is different.
1. There's a lot more simpler excel functions to do what you wanted to showcase, and you actually showed it at the beginning 2. Lambda is quite a complex function, and to use it inside SCAN without properly explaining it really defeats the purpose 3. You should have showcased SCAN first without LAMBDA, so people know what SCAN does on its own without really relying on an advanced excel formula
Awesome clear and concise explanation. Gold. I believe you said row when referring to a column? Well that’s how it works in a database. Apologies if excel is different.
Kindly provide the data you use so we can try our hands on it.
Great feedback. I'll include my templates in my article (linked above) so you can test the data yourself too.
I cant find the dataset
The article has now been updated. You can access the dataset there (it's in the second tab of the file).
1. There's a lot more simpler excel functions to do what you wanted to showcase, and you actually showed it at the beginning
2. Lambda is quite a complex function, and to use it inside SCAN without properly explaining it really defeats the purpose
3. You should have showcased SCAN first without LAMBDA, so people know what SCAN does on its own without really relying on an advanced excel formula
Thanks for the feedback! I'm glad you liked the beginning of the video. I'll make an explainer of LAMBDA in the future.
You are too jargonated! You need to break down your language in to laymens terms so people understand what you are talking about.
Thanks for the feedback! Is there a specific section of the video that's toughest to understand? I'd love to make sure everything makes sense.