Finding the Smallest Value in Google Sheets – MIN vs MINA

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