All articles with 'filter' Tag

Let’s say you have two lists of values in Excel and want to find out all the common values (ie duplicates) and extract them. In this article, let me explain the formulas for this. Formula for counting number of duplicate values in two columns: Here is the formula to count number of common values between […]

It is the Soccer WORLD CUP time. Let’s celebrate the season with an AWESOME Excel File to track game schedules, results & scores.

I have an orders table and want to see only orders from a given list of products. We can use Excel’s FILTER function to do this.

Let’s face it. You already know how to use SUMs, COUNTs and IFs and want to level up. But there are 100s of functions in Excel and you are not sure which ones to focus on.

In this article, let me reveal the top 10 important functions in Excel for data analysis work.

Excel Dynamic Array functions are going to change the way to you work your data forever. Watch the replay of the event here and learn about…

* What is so different about Excel’s dynamic array functions
* The new # operator
* 6 important dynamic array functions – FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY
* 25 practical examples of dynamic array functions for business analysis
* Your questions & answers