Well, let´s get one thing very straight - it is WE that should thank YOU. I am looking forward to each and every video that you post. Even if it is about a function / formula / etc that I have been working with for the last 30 years, I always learn something new when I watch a BCTI video. And you have a fenomenal way of explaining things. I am so very greatful that you take the time to make and post them for FREE on TH-cam. So, from me to you - Thank you 🙂🙏
I suggest you consider a tutorial on the ARRAYTOTEXT function. I don't know if there is already something on the channel. I think you can get some good examples from here. Thanks.
These are really helpful videos, please continue to produce them. Question: Looking for a solution where I am subtotaling a table, let's say by using CountA, and I want to exclude a particular date, e.g. 1/1/1920. If you can produce a video that will be great. Thanks
If you have a set of dates from A1:A101, you could try the following formula: =COUNTA(FILTER(A2:A101,A2:A101DATE(1920,01,01))) See if that works for you. Thanks for watching.
All your videos are gems❤. Thank you 🌹
@@kebincui Thank you!!!!!
we want to thank you also
@@ahmedshalaby9343 I appreciate that.
Well, let´s get one thing very straight - it is WE that should thank YOU.
I am looking forward to each and every video that you post. Even if it is about a function / formula / etc that I have been working with for the last 30 years, I always learn something new when I watch a BCTI video. And you have a fenomenal way of explaining things.
I am so very greatful that you take the time to make and post them for FREE on TH-cam.
So, from me to you - Thank you 🙂🙏
WOW! I don't know what to say. Those are very thoughtful comments. I'll try my best to keep up the expectation. Cheers!
Couldn't agree more. Looking forward for the next 100. Thanks Professor! Good job!
@ Thank you for your support!!! I does not go unnoticed.
We must thank you for your commitment and sharing your knowledge in a fantastic way.
Keep on going, you're doing a fantastic job. 🙏👍✊
@@robbe58 Thanks so much for your ongoing support.
CONGRATULATIONS, BCTI! Your videos are top notch, and I look forward to seeing more. Thank you!
That's so nice of you to say! I'll keep trying.
Your videos are great! Good luck. It's great to see the faces of those who teach us. Thank you for sharing your knowledge!
Thanks! I'm glad you enjoy the videos.
Thanks for your work 🙏🏼 I love Power Query...
I love Power Query, too!!!!! Best thing Microsoft has ever made!
Congratulations! Well deserved.
Thank you. Much appreciated.
Thank you Bryon for your videos which are excellently prepared. It is a great learning experience. You can only grow and go up!!!
I suggest you consider a tutorial on the ARRAYTOTEXT function. I don't know if there is already something on the channel. I think you can get some good examples from here. Thanks.
@@IvanCortinas_ES I'll put it on the list of upcoming videos. Thank you!!!
Thank you. Let's hope so.
Congrats and thank you for all your effort.
My pleasure.
Thank you 🌹
You are very welcome! 😊
WELL DESERVED!
Thank you!!!
Congrats 🎉
I rate your channel as one of the best, up there with excel is fun.
Thank you! I’m honored to be included in that group.
Thank you for your videos! I'm primarily interested in your Power Query, PBI, and Advanced Excel tips and tricks. Best of the season to you.
That seems to be what MOST viewers are interested in. Thanks for your viewership!
Continue to really love your channel. You explain all the concepts in a very clear way.
Thanks! I try to make everything as easy as possible.
🎉 and a toast to the next 1.5 years and another 100 videos.🎉
Thank you!
These are really helpful videos, please continue to produce them.
Question: Looking for a solution where I am subtotaling a table, let's say by using CountA, and I want to exclude a particular date, e.g. 1/1/1920. If you can produce a video that will be great. Thanks
If you have a set of dates from A1:A101, you could try the following formula:
=COUNTA(FILTER(A2:A101,A2:A101DATE(1920,01,01)))
See if that works for you. Thanks for watching.
i think the "thank you" message should come from us to you and not viceversa 😅
your work is amazing 😍
😊 thank you. That gives me much encouragement.