## Conditionally Find the Smallest Value | Google Sheets

Learn how to find the smallest value in a dataset depending on other values.

Learn how to find the smallest value in a dataset depending on other values.

MIN and MINA functions identify the smallest value in your data set but differ in handling non-numeric characters. Make a copy of this spreadsheet to follow along. MIN MINA Examples – Finding the Smallest Value Example 1: Numbers Only First, we will find the lowest number in a data set consisting only of numbers. =MIN(A2:A4) … Read more

Learn how to use the MINA function to find the lowest value in a dataset.

Learn how the MIN function finds the smallest values in a range.