MUO on MSN

Excel’s hidden REGEX and SCAN functions do way more than you expect

That's where REGEX comes in.It can handle pattern matching and text manipulation with precision. But if you pair it with the SCAN function, you can solve problems that would otherwise require multiple ...
MUO on MSN

I switched from pivot tables to GROUPBY formulas and my analysis updates itself

I can easily achieve the same result with a pivot table by dragging the Salesperson field into Rows and the Sales field into Values. It will also be nicely formatted. However, if I change anything in ...