All articles with 'top 10 values' Tag

Calculate sum of top 10 values [formulas + homework]

Published on Aug 4, 2015 in Formula Challenges, Learn Excel
Calculate sum of top 10 values [formulas + homework]

Analyzing top n (or bottom m) items is an important part of any data analysis exercise. In this article, we are going to learn Excel formulas to help you with that.

Let’s say you are the lead analyst at a large retail chain in Ohio, USA. You are looking at the latest sales data for all the 300 stores. You want to calculate the total sales of top 10 stores.  Read on to learn the techniques.

Continue »

How to select a random sample from all your data [trick]

Published on Jan 31, 2014 in Excel Howtos
How to select a random sample from all your data [trick]

The other day, I got a text message (SMS) from one of our readers. It read,

So today, let us learn a very easy trick to select random sample from your data.

Continue »

How to find sum of top 3 values based on filtered criteria [video]

Published on May 17, 2013 in Excel Howtos
How to find sum of top 3 values based on filtered criteria [video]

Lets say you are looking at some data as shown above and wondering what is the sum of budgets for top 3 projects in East region with Low priority. How would you do that with formulas?

Continue »

Show Top 10 Values in Dashboards using Pivot Tables

Published on Dec 1, 2010 in Charts and Graphs, Pivot Tables & Charts
Show Top 10 Values in Dashboards using Pivot Tables

A good dashboard must show important information at a glance and provide option to drill down for details.

Showing Top 10 (or bottom 10) lists in a dashboard is a good way to achieve this (see aside). Today we will learn an interesting technique to do this in Excel.

Continue »