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 i find a range in excel