MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Summary of Summarize Data Week


April 14, 2018 - by Bill Jelen

Summary of Summarize Data Week

For the last five days, I showed five different ways to create a customer summary from a detailed data set. Now it is time to vote for your favorite.

The goal is to summarize a 563-row data set so you have one row per customer.

This week featured five different ways to solve the problem.

There are likely other methods that I missed. Power Query. Microsoft Query.


Watch Video

Here is the summary of how long each method took, both in clicks+keystrokes and elapsed time.

Some methods are faster than the others
Some methods are faster than the others

But speed is not the whole story. Depending on if your underlying data is going to change, you might prefer a method that is easier to refresh.

I would like you to vote for the method that is your favorite. Vote here.

The results will be posted here in a few days.

This week is Summarizing Data week. Each day, we will look at five different ways to solve a problem.

Excel Thought Of the Day

I've asked my Excel Master friends for their advice about Excel. Today's thought to ponder:

"They don't call it Paste Special for nothing."

Title Photo: William Iven / Unsplash


Bill Jelen is the author / co-author of
Excel Dynamic Arrays Straight to the Point

The new Dynamic Array Functions are just one side-effect of an effort to completely rewrite the Calculation Engine in Excel. Joe McDaid and the rest of the CALC team have the laid the groundwork for all future functions in Excel. Yes, the first crop of SORT, SORTBY, FILTER, UNIQUE, SEQUENCE and RANDARRAY are awesome and powerful, but they are just the first of many new functions that will come to Office 365 over the coming years.