Excel 365 is getting new functions that bring the power of Regular Expressions (RegEx) into spreadsheets. It’s HUGE news and a big step forward for Exce| Office Watch
Aggregate() is the grown up version ‘all in one’ function that can replace common functions like Sum() and Subtotal() plus powerful options not available in| Office Watch