Thank you very much. You explain it very well and clearly.
@Aliraza147Ай бұрын
Your video tutorials on Google Sheets, Apps Script, Excel, and VBA have been incredibly valuable! I learned a lot from you. I'd love to see a future video exploring how to run a script before cell edits. While the onEdit() function is great for calculations after edits, I'm interested in functionality that triggers before the change. For example, imagine selecting a cell or range and pressing Delete. Ideally, a script would run beforehand, checking a specific condition. If the condition is met, the content would be cleared as usual. Otherwise, the script would prevent deletion. I've experimented with workarounds using onEdit(), but they haven't proven very efficient. Thanks for your continued content creation!
@ExcelGoogleSheetsАй бұрын
While this is possible in Excel VBA, it's not something that you can do in Google Sheets unless Google decided to introduce a new trigger.
@chanmeida1726Ай бұрын
@@ExcelGoogleSheets I subscribed to your website twice. But I didn't get the practice files. May I know how to get the practice files for all your videos here at KZbin?
@JerryEduardoАй бұрын
Sensational explanation! We miss these videos. Very good!
@vijaykumark2076Ай бұрын
Finally you are back.
@prosenjitshaw93617 күн бұрын
Sir you are one of the great teacher but please provide data so that i can practice. I am new in this field sir.
@DidoBohrer13 күн бұрын
Please don't stop making videos.
@guyazulayАй бұрын
Excellent video. Thanks
@Nataliia_B21 күн бұрын
Thank you for tutorial
@ExcelGoogleSheets19 күн бұрын
😊
@mattmorrisson9607Ай бұрын
This is genius! That being said, is this what you would do in a real life scenario? It seems like you had to do the entire setup first to be able to drop those variables into your formulas. While you end result is classy, does it provide any benefits over using different rows and cells for calculations?
@ronaldking10226 күн бұрын
When I hit Control-Shift-Enter on my Acer Chromebook, It doesn't auto-populate "arrayformula". I know this could be hardware specific but do you have any thoughts?
@ExcelGoogleSheets24 күн бұрын
Sorry, I've never used Chromebook, not sure what the problem is.
@marychan-e1tАй бұрын
Can you please shar the google sheet for us to practice along?
@mohdhassan2677Ай бұрын
What is the difference between let and lambda? I always can do everything in the video using lambda in the same way.
@Allen-L-CanadaАй бұрын
I had long calculations repeated 2 times, which is annoying. This will take care of it for sure. Can you use LET in Pivoit Table's calculated field?
@iiiiii-w8hАй бұрын
pivot tables use the DAX language, so no.
@Allen-L-CanadaАй бұрын
@@iiiiii-w8h thanks
@ExcelGoogleSheetsАй бұрын
You should be able to use it in Google Sheets Pivot Tables
@Allen-L-CanadaАй бұрын
@@ExcelGoogleSheets oh, thanks!
@sergheyzaporojanu6872Ай бұрын
Guys! Today I noticed something supper odd. And now I wander was it always like this? Here's the issue/bug: in both Excel and GSheets the COUNT(range) and COUNTIF(range, "") formulas are counting the cells even if they have formula that outputs "" Blank results! WHATA HACK IS EVEN THAT?!
@ExcelGoogleSheetsАй бұрын
I assume you mean COUNTA. It's been always like that.
@marychan-e1tАй бұрын
Can you please shar the google sheet for us to practice along?