Skip to main content

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

Kutools for Excel

Boosts Excel With 300+
Powerful Features

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 value 1 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 300 handy Excel add-ins, free to try with no limitation in 30 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 300 Advanced Functions for Excel 2021, 2019, 2016, 2013, 2010, 2007 and Office 365.

Kutools for Excel

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

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

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

Comments (0)
No ratings yet. Be the first to rate!
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations