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 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 CZcams?
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?
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?
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?!
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!
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.
@@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 CZcams?
Sensational explanation! We miss these videos. Very good!
Thank you very much. You explain it very well and clearly.
Please don't stop making videos.
Sir you are one of the great teacher but please provide data so that i can practice. I am new in this field sir.
Finally you are back.
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?
Excellent video. Thanks
Thank you for tutorial
😊
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?
Sorry, I've never used Chromebook, not sure what the problem is.
Can you please shar the google sheet for us to practice along?
What is the difference between let and lambda? I always can do everything in the video using lambda in the same way.
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?
pivot tables use the DAX language, so no.
@@iiiiii-w8h thanks
You should be able to use it in Google Sheets Pivot Tables
@@ExcelGoogleSheets oh, thanks!
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?!
I assume you mean COUNTA. It's been always like that.
Can you please shar the google sheet for us to practice along?