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 RU-vid?
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?!
