How to Get Started With Excel FILTER Function

In the video below, I show how to get started with the Excel FILTER function, which is available in Office 365.

You can enter a formula in one cell, and the results spill down onto the worksheet, to show all the results. And unlike other filters in Excel, the FILTER result list will update automatically, if you change the criteria.

Continue reading “How to Get Started With Excel FILTER Function”

Compare List of Numbers With Excel RANK Function

Which student got the top score? If you have test results, or another list of numbers in Excel, you could sort them to see which scores are at the top. But if you want to leave the list in alphabetical order, you can use the RANK function to show the rank for each score.

Continue reading “Compare List of Numbers With Excel RANK Function”

Pivot Table Not Sorting Correctly – Quick Fix

Usually, it’s easy to sort an Excel pivot table, but you might run into one that just won’t sort correctly! For example, employee names are listed alphabetically, but there’s a name at the top that doesn’t belong there. Why is the pivot table not sorting that one name with the others?

Continue reading “Pivot Table Not Sorting Correctly – Quick Fix”