Excel How To Find The Lowest Value In A Column

Finding the everyman value from a grouping of data is a very important and recurring job in Data Assay processes. Even for the simplest arrays, it tin exist needed, similar which product has the lowest price, or who was the fastest to terminate something. The possibilities are endless. Luckily, Excel provides some handy methods to observe it. Here, in this article, I will guide yous on how to observe the lowest value in an Excel column.

---

Download Do Workbook

You lot can download the notebook with the example used in this guide from the link beneath.

---

6 Ways to Find Lowest Value in an Excel Cavalcade

To demonstrate all the methods, I am using the same dataset below.

It shows bitcoin prices by months in dollars. I am going to await for the lowest price on the listing by different methods and in the cease, I will show y'all how to find the month when it was the lowest.

---

1. Find Everyman Value in a Column Using AutoSum Feature

Excel provides a helpful AutoSum characteristic that tin be used for and so many purposes. Just like finding out useful pieces of information like summation or average, you can easily detect out the minimum of a range.

Steps:

• Select the cell you desire your minimum value to be displayed.

• In the Dwelling tab, go to Editing Here y'all will notice the ΣAutoSum function. Click on the downward pointer abreast it. Select Min from the drop-downward list.

• Select the cavalcade y'all want the minimum value from.

• Then printing Enter.

Y'all volition have your lowest value from the column.

Read More: How to Detect Highest Value in Excel Cavalcade (iv Methods)

---

2. Using MIN Function to Find Lowest Value in a Cavalcade

You can also find the lowest values in a column by using formulas. In this section, I volition bear witness y'all how to find the minimum value using the MIN office.

Steps:

• Offset, go to the prison cell you want your minimum value to exist displayed and blazon in =MIN, and press TAB on your keyboard.

• Now, select the column you want your minimum value from. In this case, it will exist :

• And so, printing Enter. You will have your lowest value from the column.

Read More: How to Find Value in Column Using VBA in Excel (4 Ways)

---

iii. Pocket-size Function to Find Lowest Value

Likewise using the MIN function, you lot can also use the SMALL part to find out the minimum value from a column. The Modest function takes two arguments- an array of cells and the smallest m-thursday value you desire. To find the smallest one follow these steps.

Steps:

• Go to the cell y'all desire to see your minimum value in.
• So, type in the post-obit formula. (utilise ane equally your second statement as you want the smallest value of the assortment)

• Now, press Enter.

This will show you lot the smallest value from the column.

Read More: How to Get Cell Value by Row and Cavalcade in Excel VBA

---

4. Find Lowest Value in Column Using Conditional Formatting

You can use Conditional Formatting to highlight values subjected to a specific condition. This condition can be the minimum value of the agglomeration. Even while using Conditional Formatting, y'all can use ii methods to find the everyman value. The first 1 uses the formula, which is the topic of this section.

Steps:

• Select the cavalcade you want your lowest value from.

• In the Home tab, under the Styles group, you can find Provisional Formatting.
• Select it and select New Rule from the drop-down listing.

• A New Formatting Rule box will announced. Under Select a Rule Blazon select Utilise a formula to determine which cells to format. In the Formula values type in the following formula.

• You can select your prison cell style from the Format selection (I take used Fill Color green here). Then click on OK.

You lot will have your lowest value from the column formatted.

Read More: How to Find Value in Cavalcade in Excel (4 Methods)

---

5. Using "Bottom ten Items" Choice

If the higher up method including function seems a bit complicated, there is another way you lot can format your cell to show the least numerical value in a column is to use the Lesser Items feature.

Steps:

• Select the column you desire to format from.

• In the Habitation tab, under the Styles group, select Conditional Formatting.
• Select Superlative/Bottom Rules and and then select Lesser 10 Items.

• In the Lesser 10 Items box that popped upward, select or write the value one. Click on OK.

You will have the everyman value in the column formatted in this way likewise.

Read More than: Meridian 10 Values Based on Criteria in Excel (Both Single and Multiple Criteria)

---

6. Lookup Lowest Value in an Excel Cavalcade

In a practical information analysis case, you may want to observe the header or other data linked to the lowest value. In this case, you may wonder which month had the lowest bitcoin price, and for a long column, the method in this section can exist helpful.

For this method, we are going to use a combination of Index, MATCH , and MIN functions. MIN function, as shown above, will find out the everyman value in a column(or a row). Match part will detect the row(or column) where the lowest value is at. And Alphabetize function will look up the relevant information from another column of the same row (or another row of the same cavalcade).

Here is how y'all can apply it in this dataset.

Steps:

• Select the cell.

• In the cell, blazon in the post-obit formula.

=Index(B5:B11,Lucifer(MIN(C5:C11),C5:C11,0))

• Now press Enter.

You will find the month where the price was lowest.

🔎 Breakdown of the formula:

• MIN(C5:C11) finds the lowest value from the range C5 to C11, in this case, it is 38,718.
• Friction match(MIN(C5:C11), C5:C11,0) finds the row number where 38,718 is located from C5 to C11, which is ii.
• INDEX(B5:B11, MATCH(MIN(C5:C11), C5:C11,0)) will show the value of the second jail cell from range B5:B11, Feb 2022.

Read More: Lookup Value in Column and Render Value of Another Column in Excel

---

Determination

That concludes all the methods to notice the everyman value in an Excel column. I hope you find this article informative and easy to digest. If y'all have any questions or whatsoever suggestions, feel free to let u.s.a. know. For more guides similar this, try exploring Exceldemy.com.

---

Related Articles

• How to Find Beginning Occurrence of a Value in a Column in Excel (five Ways)
• Find Tiptop 5 Values and Names in Excel (8 Useful Ways)
• How to Find Final Occurrence of a Value in a Column in Excel (5 Methods)

Source: https://www.exceldemy.com/find-lowest-value-in-excel-column/

Share this post