• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Range in Excel

March 18, 2021 by Andrew Childress
Range in Excel

Range measures the difference between the minimum and maximum values in a given dataset. Let's learn how to calculate range in Excel.

Range is one of the most useful and common data measurements. It measures the difference between the minimum and maximum values in a given dataset. Let’s learn how to calculate range in Excel.

How to Calculate Range in Excel (With Formulas)

Excel offers two easy ways to find the range of your dataset. Consider a table of data showing past sales. You want to find the range of the sales figures.

Click into an empty cell, then type = to begin a formula. Then, type MAX(. Click and drag to select your dataset, in this case, the Sales Price column.

Close with ).

Max from data list

Your formula will look like this:

=MAX(A2:A10)

Then press Enter on your keyboard. This gives you your maximum value.

Now, you need to find the minimum value. The process is very similar. In another empty cell, input the following formula:

=MIN(A2:A10)

Min Excel data

When complete, you’ll have both values. To find your range, simply subtract the minimum value from the maximum value.

In another empty cell, type =, then click on your maximum cell. Type -, then click on the minimum cell.

=D1-D2

Calculate range Excel

Pressing Enter returns the value of $707,000, which is your range.

How to Calculate Range (With Filters)

If you have a smaller data set, or don’t want to use formulas, you can find the range of a dataset with the help of filters.

Click into cell A1, Sales Price. On the Home tab, click on Sort & Filter. Click on the Filter icon.

Filter Excel spreadsheet

Next, click the dropdown arrow that appeared in your cell. On the dropdown, choose the second option: Descending (or Sort Largest to Smallest). The top number is your maximum value; the bottom number is your minimum.

Sort largest to smallest

To compute range, find an empty cell and subtract the bottom value from the top value. Here, your formula would look like this:

=A2-A10

Press Enter, and you’ve computed the range of your data.

Sorted subtraction Excel

Excel makes finding the range of data a breeze, thanks to formulas and filters.

Category: Excel FormulasTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Shift in copy formula ExcelCopy a Formula in Excel
Next Post:Insert Multiple Rows in ExcelMid rows selected Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top