Excel MIN Function Archives

Excel MIN Function Returns 0: 2 Possible Scenarios

Jul 22, 2024

We're going to cover the cases where the Excel MIN function returns 0, as well as some workarounds to deal with this. Here's an overview of the ...

Excel MIN Function Returns 0: 2 Possible Scenarios

How to Use the MIN Function to Exclude Zero in Excel – 5 Easy Methods

Feb 20, 2025

To find the minimum value and exclude zeros in a dataset or an array, you can use the MIN function. This dataset includes Product ID, Product ...

How to Use the MIN Function to Exclude Zero in Excel – 5 Easy Methods

How to Find Minimum Value That Is Greater Than 0 in Excel

May 29, 2024

Finding the smallest value other than zero can be cumbersome if we consider a large dataset. However, we can use the LARGE, COUNTIF, SMALL, ...

How to Find Minimum Value That Is Greater Than 0 in Excel

How to Use Combined MIN and IF Functions in Excel (2 Ways)

Jul 1, 2024

Here, we have the sales data of three different brands for two different products along the location of their stores. We will apply a single ...

How to Use Combined MIN and IF Functions in Excel (2 Ways)

Difference Between MAX and MIN Function in Excel

Nov 11, 2025

The MAX and MIN functions are very frequently used in Excel. These functions have a wide range of uses. In this article, we determine the difference ...

Difference Between MAX and MIN Function in Excel

How to Find Lowest 3 Values in Excel: 5 Easy Ways

Jun 3, 2024

Method 1 - Using SMALL Function Step 1: Click on any cell E5. Insert the formula: =SMALL(C5:C10,1) Step 2: Press ENTER. The First lowest ...

How to Find Lowest 3 Values in Excel: 5 Easy Ways

How to Find Minimum Value with VLOOKUP in Excel (6 Ways)

Jul 9, 2024

We will use the following data table to explain the methods to find minimum value with VLOOKUP in Excel. Method 1 - Minimum Value with ...

How to Find Minimum Value with VLOOKUP in Excel (6 Ways)

How to Find Minimum Value Based on Multiple Criteria in Excel

Jun 11, 2024

Method 1 - Find the Minimum Value Based on Multiple Criteria Using MIN and IF Functions Let’s assume we have a food order dataset with their product ...

How to Find Minimum Value Based on Multiple Criteria in Excel

How to Find the Lowest Value with Criteria in Excel – 7 Methods

Aug 6, 2024

This is the sample dataset. Method 1 - Combine Excel MIN & IF Functions to Get the Lowest Value 1.1. Single ...

How to Find the Lowest Value with Criteria in Excel – 7 Methods

How to Find the Minimum Value in Excel – 6 Easy Methods

Aug 4, 2024

This is the sample datset. Method 1 - Using the MIN Function to Find the Minimum Value in Excel The syntax for the MIN function is ...