How To Find The Lowest Value In Excel
Finding the lowest value from a group of data is a very important and recurring task in Data Analysis processes. Even for the simplest arrays, it can be needed, similar which production has the lowest price, or who was the fastest to finish something. The possibilities are endless. Luckily, Excel provides some handy methods to find it. Hither, in this article, I will guide you on how to notice the lowest value in an Excel cavalcade.
Download Practice Workbook
You tin can download the notebook with the example used in this guide from the link beneath.
6 Ways to Notice Lowest Value in an Excel Cavalcade
To demonstrate all the methods, I am using the same dataset below.
It shows bitcoin prices past months in dollars. I am going to wait for the everyman price on the list past different methods and in the end, I will show you how to notice the month when it was the lowest.
1. Observe Everyman Value in a Column Using AutoSum Feature
Excel provides a helpful AutoSum characteristic that can be used for then many purposes. Just like finding out useful pieces of information like summation or average, you can hands find out the minimum of a range.
Steps:
- Select the prison cell you want your minimum value to be displayed.
- In the Abode tab, go to Editing Here you volition find the ΣAutoSum part. Click on the downward arrow beside it. Select Min from the drop-down list.
- Select the cavalcade you want the minimum value from.
- Then press Enter.
You will take your lowest value from the column.
Read More: How to Detect Highest Value in Excel Cavalcade (4 Methods)
2. Using MIN Role to Find Everyman Value in a Column
You lot can as well find the everyman values in a column by using formulas. In this section, I will show you how to discover the minimum value using the MIN part.
Steps:
- Outset, go to the jail cell y'all want your minimum value to be displayed and type in =MIN, and press TAB on your keyboard.
- Now, select the column yous desire your minimum value from. In this instance, information technology volition be :
- Then, press Enter. You will have your everyman value from the column.
Read More than: How to Find Value in Column Using VBA in Excel (4 Ways)
3. Small-scale Part to Discover Lowest Value
Besides using the MIN function, you tin can too apply the Pocket-size function to find out the minimum value from a column. The SMALL office takes ii arguments- an array of cells and the smallest k-th value you desire. To find the smallest one follow these steps.
Steps:
- Go to the jail cell you lot want to see your minimum value in.
- And so, type in the following formula. (use 1 as your second argument as y'all desire the smallest value of the array)
- Now, press Enter.
This will show you the smallest value from the column.
Read More: How to Get Prison cell Value past Row and Cavalcade in Excel VBA
4. Find Lowest Value in Cavalcade Using Conditional Formatting
Yous tin can utilize Provisional Formatting to highlight values subjected to a specific condition. This condition tin can be the minimum value of the bunch. Even while using Conditional Formatting, you lot tin utilise two methods to notice the lowest value. The kickoff one uses the formula, which is the topic of this section.
Steps:
- Select the column y'all want your lowest value from.
- In the Domicile tab, nether the Styles grouping, you lot tin can find Conditional Formatting.
- Select it and select New Dominion from the drop-down list.
- A New Formatting Rule box will appear. Under Select a Rule Type select Use a formula to determine which cells to format. In the Formula values type in the following formula.
- You can select your cell style from the Format option (I have used Fill up Color green here). And so click on OK.
Yous will have your everyman value from the column formatted.
Read More than: How to Detect Value in Column in Excel (4 Methods)
5. Using "Lesser ten Items" Option
If the above method including function seems a chip complicated, at that place is some other style y'all can format your cell to bear witness the least numerical value in a column is to use the Bottom Items feature.
Steps:
- Select the cavalcade you want to format from.
- In the Abode tab, under the Styles group, select Conditional Formatting.
- Select Elevation/Bottom Rules and then select Bottom 10 Items.
- In the Bottom ten Items box that popped up, select or write the value one. Click on OK.
You will have the lowest value in the column formatted in this way also.
Read More than: Top 10 Values Based on Criteria in Excel (Both Single and Multiple Criteria)
six. Lookup Lowest Value in an Excel Cavalcade
In a practical data assay case, y'all may want to observe the header or other information linked to the lowest value. In this example, y'all may wonder which month had the everyman bitcoin price, and for a long column, the method in this department can exist helpful.
For this method, nosotros are going to apply a combination of INDEX, Match , and MIN functions. MIN office, as shown higher up, will detect out the everyman value in a column(or a row). MATCH function will find the row(or cavalcade) where the lowest value is at. And INDEX function will look upward the relevant data from some other column of the same row (or another row of the same column).
Hither is how you can use it in this dataset.
Steps:
- Select the prison cell.
- In the prison cell, type in the following formula.
=Index(B5:B11,Lucifer(MIN(C5:C11),C5:C11,0))
- Now press Enter.
You will find the month where the cost was everyman.
🔎 Breakdown of the formula:
- MIN(C5:C11) finds the lowest value from the range C5 to C11, in this case, it is 38,718.
- MATCH(MIN(C5:C11), C5:C11,0) finds the row number where 38,718 is located from C5 to C11, which is two.
- INDEX(B5:B11, MATCH(MIN(C5:C11), C5:C11,0)) volition bear witness the value of the second cell from range B5:B11, February 2022.
Read More: Lookup Value in Cavalcade and Return Value of Some other Column in Excel
Decision
That concludes all the methods to observe the lowest value in an Excel column. I hope you lot find this article informative and like shooting fish in a barrel to digest. If you have whatsoever questions or any suggestions, experience free to let united states of america know. For more guides like this, try exploring Exceldemy.com.
Related Articles
- How to Find Showtime Occurrence of a Value in a Column in Excel (v Ways)
- Discover Top 5 Values and Names in Excel (8 Useful Ways)
- How to Detect Last Occurrence of a Value in a Column in Excel (5 Methods)
Source: https://www.exceldemy.com/find-lowest-value-in-excel-column/
0 Response to "How To Find The Lowest Value In Excel"
Post a Comment