If you are hoping to find the minimum value greater than zero in your large Excel dataset, you have come to the right place. As business analysts, we use Excel functions to look for specific values for our analysis. In this article, we will start from scratch and learn **5** easy ways to find the minimum value that is greater than **0** in Excel.

Letâ€™s take a look at the overview of this article which represents the finding of the minimum value greater than **0**. You will learn about the methods in the next section of the article.

## How to Find Minimum Value That Is Greater Than 0 in Excel: 5 Suitable Ways

Finding the smallest value other than zero can be cumbersome if we consider a large dataset. However, we can use the **LARGE**, **COUNTIF**, **SMALL**, **COUNTIFS**, **AGGREGATE** functions, **Array **formula, and Excel **VBA** to easily determine the values. Therefore, letâ€™s jump into the methods.

### 1. Utilize Excel Array Formula to Get Minimum Value That Greater Than Zero

The first step aims to use the **Array formula** to get the smallest positive integers in our dataset. Follow the below steps to do so.

__Steps:__

- Initially, type the following array formula in cell
**D11**,

`=MIN(IF(C5:C9>0,C5:C9))`

- Afterward, press
**Ctrl + Shift + Enter**keys since this is an**array formula**.

- Thus, we obtain the smallest sale
**$8.00**excluding**$0.00**.

__Formula Breakdown__**IF(C5:C9>0, C5:C9)**specifies the logical condition in range**C5:C9**where the value is greater than**0**.**MIN(IF(C5:C9>0, C5:C9))**returns the minimum value greater than**0.**

**Read More: How to Find Minimum Value in Excel**

### 2. Combine LARGE and COUNTIF Functions to Find Minimum Value That Is Larger Than 0 in Excel

The objective of the second step is to combine the following functions. Firstly, **the LARGE function** returns the **K**-th largest value in a dataset where **K** is a positive integer. Secondly, **the COUNTIF function** returns the total number of occurrences of a specific value. Now, see the below procedure to join them.

__Steps:__

- Firstly, write the combined formula in cell
**D11**.

`=LARGE(C5:C9,COUNTIF(C5:C9,">0"))`

- Later, press the
**Enter**or**Tab**keys to see the output as**$8.00**.

- Hence, we obtained our desired result.

__Formula Breakdown__**COUNTIF(C5:C9,”>0″)**counts the occurrences of the value that is greater than**0**in column**C**.**LARGE(C5:C9, COUNTIF(C5:C9,”>0″))**returns the minimum number greater than zero.

**Read More: ****How to Use MIN Function to Exclude Zero in Excel**

### 3. Merge SMALL and COUNTIFS Functions to Display Smallest Value Greater Than 0

In our third step, we will combine the **SMALL** and **COUNTIFS** functions before implementing the formula. The **SMALL **function returns the n-th smallest value in a dataset. Again, the **COUNTIFS **function returns the total occurrences of a given value in multiple criteria. Follow the below steps to combine them.

__Steps:__

- First, in cell
**D11**, type the combined formula.

`=SMALL(C5:C9,COUNTIFS(C5:C9,0)+1)`

- Next, press the
**Enter**key.

- As a result, the smallest value other than
**zero**,**$8.00**pops up.

__Formula Breakdown__**COUNTIFS(C5:C9,0)**counts the total**0**in the range**C5:C9**.**SMALL(C5:C9, COUNTIFS(C5:C9,0)+1)**specifies the greater values than**zero**and returns**1**output.

**Read More: ****How to Find Minimum Value with VLOOKUP in Excel**

### 4. Use AGGREGATE Function to Look for Minimum Value That Is Larger than Zero in Excel

**The AGGREGATE function** includes different functions like **AVERAGE**, **COUNT**, **MAX**, **MIN**, **SUM**, **PRODUCT**, **LARGE,** etc. with the **Option** to omit hidden rows and error values to get certain results. In this case, we will use the **AGGREGATE **function number **14** ( **LARGE function**) and **Option 6** which represents omitting error values. See the steps below.

__Steps:__

- To begin with, add the formula in cell
**D11**:

`=1/AGGREGATE(14,6,1/C5:C9,1)`

- Here,
**AGGREGATE (14, 6)**represents the**LARGE**function with the**Omit Error Value Option**. - Pressing
**Enter**will thoroughly get you the output.

**Read More: How to Find Minimum Value Based on Multiple Criteria in Excel**

### 5. Run a VBA Code in Excel to Determine Minimum Value That Is Greater than 0

In our last method, we will use a **VBA** code to find the smallest sale greater than **0**. Carefully follow the given steps.

__Steps:__

- Firstly, go to the
**Developer**tab and click**Visual Basic**.

- Subsequently, the
**Visual Basic**window pops up. - There, tap the
**Insert**tab and then**Module**to create a module box.

- In the
**Module**box, type the following**VBA**code:

```
Sub SOFTekoMinVALUE()
ActiveCell.FormulaR1C1 = _
"=SMALL(R[-6]C[-1]:R[-2]C[-1],COUNTIFS(R[-6]C[-1]:R[-2]C[-1],0)+1)"
MsgBox "Minimum Value Greater than Zero is " _
& Worksheets("Excel VBA").Range("D11")
End Sub
```

- Lastly, hit the green
**Run**icon.

- Consequently, the desired output appears in a
**message box**.

**Read More: How to Find Lowest Value with Criteria in Excel**

**Download Practice Workbook**

Download this workbook and practice while going through the article.

## Conclusion

In conclusion, we have discussed some easy steps to find the minimum value that is greater than **0** in Excel.Â Please, leave any further queries or recommendations in the comment box below.

## Related Articles

**How to Use Combined MIN and IF Function in Excel****Difference Between MAX and MIN Function in Excel****How to Find Lowest 3 Values in Excel****Excel MIN Function Returns 0**

**<< Go Back toÂ Excel MIN Function | Excel Functions | Learn Excel**