Excel Magic Trick 1506: Power Query to Extract All Numbers Listed in Single Cell and Add for Total

Download Excel Files: Start File: https://ift.tt/2JTdGMf
Finished File: https://ift.tt/2HKb5zf
Entire page with all Excel Files for All Videos: https://ift.tt/1kSFWvs

In this video see how to add all the numbers listed in a single cell using Power Query and the simple steps: 1) Split down Rows by a Space Delimiter, 2) Filter with Begins By “$”, 3) Group By to add numbers for each transaction.
Thanks to Bill Szysz for help with this trick.

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.