Find the Range To find the range using Excel, you must first find the max and min values for the dataset and then use the subtract function to calculate the difference between them. 1. Begin with a blank spreadsheet open in Excel 2. Key in the following data, entering one numeral per cell in consecutive cells of the same row, beginning in cell A2 and ending in cell K2: 2, 3, 4, 5, 5, 6, 9, 77', 5, 4, 3 3. Use the max function to find the max value of the dataset in cell L2. 4. Use the m=infunction to find the min value of the dataset in cell L3. 5. Use the subtract function to find the range of the dataset. Type in the following formula in cell L5: =L2-L3 6. Click out of cell L5, and the range should appear in this cell. ?. Insert vour snapshot here