How to select minimum data with min function in Excel 2007/2010?

When you open a worksheet, there are hundreds of data in the cells, if you want to look for the minimum data, how should you do? It is tedious and time-consuming for you to pick up it one by one, normally we will select minimum data according to following procedures.

Using Min function to get the minimum data;

A multifunction tool to select the minimum data and locate the numbers in worksheet quickly.

Using the Min function to get the minimum data

In a worksheet, select a blank cell to apply the min function, then Click Formula > Autosum > Min, and Select the range that you want to get the minimum data. See screenshot:

doc-min-function-1

Then press the Enter key to get the minimum data. The minimum value will be displayed in the cell. See screenshot:

doc-min-function-2

As you seen in the above screenshot, the minimum data is displaying in the cell. But with this min function, you can only get one minimum data, what if you want to know where and how many minimum data there are, this method will not go to work. To solve this matter, I will introduce you the multifunction tool Kutools for Excel.

Kutools for excel: with more than 80 handy Excel add-ins, free to try with no limitation in 30 days. Get it Now

A multifunction tool to select the minimum data and locate the numbers in worksheet quickly

After installing Kutools for Excel, select the range you want to use, then click Kutools >> Select tools >> Select cells with max or min value…, there will be a dialog box. See screenshot:

doc-min-function-3

Then choose Minimum value option from Go to, and choose All cells from Select, select Formula and value cells from Look in dropdown list,. Click OK. See screenshot:

doc-min-function-4

From this screenshot, we can see the exact location of the selected minimum data.

Note: All Cell option will select and locate all minimum data from the range. First Cell Only option will only select the first minimum data of the range.