How to find range in Google Sheets

You can watch a video tutorial here.

When working with a list of numbers, you may need to find the range of data. This is the difference between the lowest and the highest value in the list. In Google Sheets, there are 2 ways of doing this. One is using the MIN() and MAX() functions and the second is to sort the data.

1. MIN(): this returns the minimum value from a set of numbers
   1. Syntax: MIN(range of numbers)
2. MAX(): this returns the maximum value from a set of numbers
   1. Syntax: MAX(range of numbers)

Option 1 – Use the functions

Step 1 – Find the minimum value

• Select the cell where the result is to be displayed
• Type the formula using cell references:

=MIN(range of Height (cm))

• Press Enter

Step 2 – Find the maximum value

• Select the cell where the result is to be displayed
• Type the formula using cell references:

=MAX(range of Height (cm))

• Press Enter

Step 3 – Check the result

• The range starts from the minimum value and ends at the maximum value

Option 2 – Sort the data

Step 1 – Open the Sort box

• Select the column or list of values
• Right-click and go to View more cell actions > Sort range

Step 2 – Define the parameters

• Tick the Data has header row box
• Select the sort order (A to Z)
• Press Sort

Step 3 – Check the range

• The first value in the list is the start of the range
• The last value in the list is the end of the range