How to Use SUMPRODUCT With Multiple AND Criteria
There are situations where several criteria are required to add up the right numbers. That’s straightforward if the numbers are found in a single column …
2 Tricks to Generate All Unique Combinations From Multiple Columns in Power Query
Power Query allows you to easily produce all value combinations from lists or columns. This can be useful for when you prepare your dataset for …
2 Ways to Rank With Ties Using Power Query
Recently I worked on a challenge from Ken Puls, where I needed to figure out how to Rank With Ties. Ken had a set of …
Transform Stacked Column into a Table with Power Query
Data comes in countless ways and forms. Sometimes structured, with an SQL database, a table in Excel or several CVS files. The fun with Power …
How to Group By Maximum Value using Table.Max – Power Query
In an earlier article, I showed a basic example of how to group data. The grouping functionality takes your data, let’s you perform some operations with …
How to Group or Summarize Data – Power Query
Many times, Excel users need to show their data in a summarized way. Go-to tools for many are PivotTables or formulas as SUMIFS, SUMPRODUCT, AGGREGATE …
Import Multiple Files from a Folder with Power Query
In this post you will learn how to import files from a folder. Power Query makes it possible to import all Excel files from a …
Beginners Guide: How to Use the SUMPRODUCT Function in Excel
SUMPRODUCT is a multi-purpose formula. In essence, it multiplies arrays and returns the sum of those products. It is different from most Array formulas in …
How to ROUND a Number to the Nearest 1000
Financial reports can sometimes be very messy to look at. Whereas consumers want to understand the big picture, sometimes the numbers are so detailed, they …
