This Simple Excel Trick Makes Dynamic Filters Update Themselves in Seconds

Learn how DROP, REDUCE, LAMBDA, and STACK make Excel arrays update automatically, split text, and stack filtered results ...

Stop Using Basic Excel Drop-Downs : 5 Advanced Tricks For Dynamic Drop-Downs

Discover 5 advanced Excel drop-down techniques to create dynamic, auto-updating lists and improve your data management skills.
JournalofAccountancy

Using Excel’s TEXTBEFORE AND TEXTAFTER functions to easily tame messy data

If you would like to follow along in using these functions, you can download this Excel workbook and view the video at the end of this item. Let’s do some examples to see how these functions work. We ...