". . . or if your data's in a right old mess . . ." LOL! That comment hit home with me because some people try to use Excel as though it were a word processer AND a spreadsheet program. Good stuff.
You are an awesome presenter! I've scratched my head after watching so many videos that make BIG claims about my "mastery" of Dynamic Array Functions, but I've learned more "applicable" techniques in 3/4 of an hr. than all that blah, blah, blah I sat through combined! Thank you. I have a question for you: In the last argument of the IFNA formula using TEXTBORE(TEXTAFTER), you input " ". Why didn't you input "", instead. Is there a reason to insert a space into those cells? Keep up the good work Deborah!
Thank you so much for your kind words! Glad to hear that you found the techniques useful and practical. Using " " is a formatting choice to ensure consistency across the data 😊
Thanks a bunch for the shoutout, I'm glad you found it helpful! 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
". . . or if your data's in a right old mess . . ." LOL! That comment hit home with me because some people try to use Excel as though it were a word processer AND a spreadsheet program. Good stuff.
Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
You are an awesome presenter! I've scratched my head after watching so many videos that make BIG claims about my "mastery" of Dynamic Array Functions, but I've learned more "applicable" techniques in 3/4 of an hr. than all that blah, blah, blah I sat through combined! Thank you. I have a question for you: In the last argument of the IFNA formula using TEXTBORE(TEXTAFTER), you input " ". Why didn't you input "", instead. Is there a reason to insert a space into those cells? Keep up the good work Deborah!
Thank you so much for your kind words! Glad to hear that you found the techniques useful and practical. Using " " is a formatting choice to ensure consistency across the data 😊
Excellent Deborah for the session, need more of such sessions from you.
Awesome Deborah Asby, concise, crystal clear! Well done!
Thanks a bunch for the shoutout, I'm glad you found it helpful! 😊
🔥Check out our FREE 300+ hour training course playlist here 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU