Select the cell for the second largest value.Replace array with the range of cells, here 2 tells excel to get the second smallest number. First select the cell where we want to get the second smallest value.You want to calculate the range from the second largest & second smallest value, in such a case we can use SMALL() & LARGE() function. Let’s say now you’re not just interested in the largest or smallest value from a given range. Method 2: Excel Range in Formula for Top k & Bottom K values In just one formula you’ll get the value of range. One other faster way to do this, is to just type one formula.Which will subtract the values in E5(max) and E4(min). Now select the final cell where you want to calculate the range value.This functions tells excel to find the minimum value from the range of cells. Again, here also replace array with the range of cells. Now select the cell, where you want to display the maximum value from range.Just select the range of cells by dragging the cells. Here replace array with the range of cells. First select the cell, where you want to display the minimum value from the range.Method 3: Calculate range in excel using Conditional Max & Min Formula.Method 2: Excel Range in Formula for Top k & Bottom K values.

How do i find a range in excel