Suppose a manager keeps the product sale data that include model, unit price, state, number of units, and the total revenue of every product/state. The lowest and highest figures within the data group are useful for accurate decision-making, forecasting, and budgeting. The rows and columns have the lowest and highest values of sales, revenues, or other useful information. Several businesses do not have enough time to waste sorting the data through columns and rows. The only difference is that you can check the range using the MIN and MAX function in the excel worksheet. The same procedure you need to follow in excel.

This is how you calculate the range of the dataset in mathematics with a simple formula. Therefore, the range will be 60 – 5 = 55. Now, you can see that the largest number in the given dataset is 60, whereas the smallest number of the dataset is 5. Suppose you have a list of different values as: To know the exact procedure of the range in excel, let’s take an example. In the below image, the highlighted cells are: (A1:C4, E1, E4, B6). The below image shows the range as (A1:C4).Ī range consists of cells that are not contiguous or might have irregular geometrical shapes whenever they are highlighted. This kind of range usually looks like a rectangle or square within the spreadsheet whenever they are highlighted. It is the range of the cells that are located at the adjacent position to one another. What are the two types of ranges used in Excel? Symmetrical Range When you get the minimum and maximum value of the number, then subtract the MIN value from the MAX value. Now, to find out the range of the numbers, you require to find out the maximum or upper and minimum or lower value using MAX & MIN functions. Or we can say that range is used to define the spread of values within the datasets.įor example, suppose you select 10 different numbers randomly within the list of excel. Now, the question is, what is the range? Well, a range is the combination of various value spreads that lies between the minimum and maximum value. Moreover, the range can be non-adjacent or adjacent cells within the dataset. A Comparison Table: Excel Table vs RangeĪs we have already mentioned that when a user talks about the range in excel, then there is a possibility that he/she talks about the single cell or the group of cells.What are the two types of ranges used in Excel?.

How do you find a range in excel