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
MrExcel LIVe

A book for people who use Excel 40+ hours per week. Illustrated in full color.