Log in
x
or
x
x
Register
x

or

Select max or min (smallest or greatest) value cell in Excel

Excel's MIN or MAX function can only identify the max or min value in a range, but it cannot locate and select the cells containing max or min values. Kutools for Excel’s Select Cells with Max & Min Value tool can help you quickly select the cells with maximum or minimum value.

Select the minimum values of first cell or all cells

Select the maximum values of first cell or all cells

Select the maximum/minimum values of each row or column


Click Kutools >> Select >> Select Cells with Max & Min Value. See screenshots:

shot select max min value1 arrow-big shot select max min values 2

Select the minimum values of first cell or all cells

1. Highlight the range that you want to select the smallest values.

2. In the Select Cells With Max & Min Value dialog box, specify the type of cells to search (formulas, values, or both) in the Look in box.

3. Then check Minimum value from Go to option, and check Cell option in Base section, if you want to select the first matching cell, just choose the First cell only option, to select all the matching cells, please choose All cells option. See screenshot:

shot select max min values 3

4. And then click OK. A prompt box will remind you how many cells will be selected. See screenshot:

shot select max min values 4

5. Click OK. All of the smallest values have been selected. See screenshot:

shot select max min values 5


Select the maximum values of first cell or all cells

1. Select the range and apply this utility.

2. Go to the Select Cells With Max & Min Value dialog box, specify the type of cells to search (formulas, values, or both) in the Look in box.

3. Then check Maximum value from Go to option, then select Cell in the Base section, if you want to select the first matching cell, just choose the First cell only option, to select all the matching cells, please choose All cells option. See screenshot:

shot select max min values 6

4. And then click OK. A prompt box will remind you how many cells will be selected. See screenshot:

shot select max min values 7

5. Click OK. All of the greatest values have been selected. See screenshot:

shot select max min values 8


Select the maximum/minimum values of each row or column

1. Select the range and apply this utility.

2. Go to specify the type of cells to search (formulas, values, or both) in the Look in list box.

3. Then check Maximum value or Minmum value in the Go to section, and check Entire row or Entire column in the Base section, then go to Select section to choose First cell only or All cells. See screenshot:

shot select max min values 9

4. Click Ok, and a prompt box will tell you the number of selected cells, just click OK to close it. Now the maximum value in each row or column have been selected. See screenshot:

Select Maximum value base on entire row
shot select max min values 10
Select Maximum value base on entire column
shot select max min values 11

Demo: Select the maximum / minimum values in a range or each row or column

Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!


Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 200 Advanced Functions for Excel 2016, 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013, 2016 and 365, as if it were Office 2000 and 2003.

Kutools for Excel

The functionality described above is just one of 200 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.

Screen shot of Kutools for Excel

btn read more     btn download     btn purchase

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.