Monday, July 26, 2021
I used the FILTER function to give me IFS-like power for PERCENTILE.INC. But then I realized the same pattern brings IFS-like power to many functions—including MEDIAN, STDEV.S, GEOMEAN, and perhaps even the FORECAST functions!

Using the Hidden Power of Excel’s FILTER Function

When you take the time to explore a new worksheet function, it's amazing what you can discover! And I won't tell you about the really...

Latest Articles

Excel users made such a mess of nested IF functions that Microsoft created the IFS function to help. Here's how to tame both functions.

How to Tame Nested IF Functions in Excel

When I review my Excel formulas from many years ago, one of the types of formulas that I'm most embarrassed about today is the...
Excel's STOCKHISTORY function can return decades of history about the prices of stocks for thousands of public companies from many countries. Here's an introduction to that function.

Introducing Excel’s STOCKHISTORY Function

The STOCKHISTORY function recently showed up in my non-beta version of Excel 365. Its appearance was a surprise because it wasn't announced as a What's...

A Lesson in Excel Analysis Learned from Rising US Inflation

Looking at the trends in the annual rate of change (ROC) of business and economic measures is an excellent way to reveal hidden information...
Advertisement
Advertisement