If you’re like most people, you use Microsoft Excel to manage your finances, track your expenses, and keep track of your schedule. But what if you want to do more than just work with Excel? What if you want to use Excel to create charts and graphs, or write reports? In this article, we’ll show you how to find range in Microsoft Excel so that you can do all of these things. To start, open Microsoft Excel and click the “Home” tab on the ribbon. Under “Data”, click “Range”. In the “Range” window that opens, select the cells that you want to work with. For example, if you want to create a chart that shows how much money each person in your family has spent this year, select the cells A1:D10. Now it’s time to start working with range. To create a chart in Microsoft Excel, first select the data that you want to include in the chart and then click on the “Chart” button on the ribbon. In the “Chart Options” window that opens (see below), select which type of chart you want to create (line or bar) and then choose which data points will be included in the chart (by clicking on the checkboxes next to each column of data). Finally, click on OK to close the “Chart Options” window and start creating your chart! To write a report in Microsoft Excel, first open a new document by clicking on File > New > Document. Next, under “Type of document,” choose “Report.” In the “Report Options” window that opens (see below), select which type of report you want to create (table or graph) and then choose which data points will be included in your report (by clicking on the checkboxes next to each column of data). Finally, click on OK to close the “Report Options” window and start writing your report! ..
If you’re using Microsoft Excel for statistical data, you may need to find the range for a data set. Here we’ll explain a simple way to calculate range in Excel using formulas.
Calculating Range
Simply put, the difference between the highest and lowest numbers in a data set is known as range. If the range is high, then the data set is spread out further than if the range is low.
As an example, this data set includes the numbers 10, 25, 50, 75, 100. To find the range, you subtract 10 (lowest number) from 100 (highest number). Here, the range is 90:
While this is a simple example, it’s not always that easy to view your data set and do the subtraction. You may have many numbers in your data set, and they may be in varying order rather than ascending or descending. So, spotting and subtracting the highest and lowest values might not be a quick process.
In Excel, you can use the MAX and MIN functions to find the highest and lowest values. Then, do the subtraction: MAX – MIN = Range.
How to Calculate Range in Excel
Open your Excel sheet and select the cell where you want to display the range for your data set. For this example, we have our numbers in cells A1 through A5 and use this formula:
The first part of the formula, MAX(A1:A5), finds the highest value in the data set. The second part, MIN(A1:A5), finds the lowest value. The minus sign in between subtracts MIN from MAX, giving us our range: 100 – 10 = 90.
Find a Conditional Range
You may have a situation where you need to find the range of your data set but want to exclude certain data. For instance, maybe you have temporary figures for sales or revenue that you want to eliminate when calculating range.
RELATED: How (and Why) to Use the Outliers Function in Excel
You can add a condition to the MAX function using MAXIFS or the MIN function using MINIFS. The syntaxes are MAXIFS(max_range, criteria_range, criteria) and MINIFS(min_range, criteria_range, criteria). Let’s look at an example.
Here we have a data set in cells C1 through C5 where we want to calculate range but include only the high values, those above 500. We would use this formula:
The first part of the formula, MAX(C1:C5), finds the highest value in the data set. The second part, MINIFS(C1:C5,C1:C5,">500"), finds the lowest value in those same cells but requires the values in those cells be higher than 500. And of course, the minus sign is our subtraction to calculate the range.
So rather than determining range with 5000 – 10 = 4990, the range is calculated as 5000 – 1000 = 4000, excluding those numbers below 500.
Check out Microsoft’s Support pages for these conditional functions if you’re interested in other ways to use MAXIFS or MINIFS.
Finding range in your Excel spreadsheet is as easy as a formula using a couple of functions. And for those who need to take it further, you can add conditions to those formulas.
For additional help, take a look at some basic functions you should know about in Excel.
