If you can write an Excel formula, you can build your own function.
How-To Geek on MSN
I built my own Excel toolbar using basic VBA, and it works in every spreadsheet I open
VBA may have a bad reputation, but it's still one of the most effective ways to automate repetitive actions in standard XLSX ...
There is a common mistake that people who have learned Power Query tend to make: trying to do everything with Power Query. Power Query is not a panacea. It is important to understand what it excels at ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results