Use the MIN function to find the lowest number when ready

The fastest way to find the lowest number in a Google Sheet is to use the MIN function. Type =MIN() into any empty cell, put the range of numbers you want to search inside the parentheses, and Google Sheets returns the smallest value. If you have 50 numbers in column A, rows 1 through 50, you would type =MIN(A1:A50) and the lowest number appears in that cell.

MIN works with any range — a single column, a single row, multiple columns, or scattered cells. It ignores empty cells and text. If your data includes both numbers and words (like a column of prices mixed with product names), MIN skips the words and finds the lowest price.

The function returns a number, not a cell location. If you need to know which row contains the lowest value, you will need a different approach, covered below.

Key Takeaways

  • The MIN function finds the lowest number in any range: type =MIN(A1:A50) to search column A, rows 1 through 50.
  • MIN ignores empty cells and text, so it works in columns that mix numbers with other data.
  • To find which row holds the lowest number, combine MIN with MATCH inside an INDEX function.
  • You can use MIN across multiple sheets by typing the sheet name before the range: =MIN(Sheet2!A1:A50).
  • MIN returns an error if the range contains no numbers at all, which tells you the data format may be wrong.

Set up the MIN formula in three steps

Click on an empty cell where you want the result to appear. This is usually below or to the right of your data, somewhere visible and straightforward to find later.

Type the equals sign to start a formula: =MIN(. Then highlight or type the range of cells you want to search. If you click and drag across the cells, Google Sheets fills in the range automatically. Close the parenthesis and press Enter.

Google Sheets calculates the result and shows the lowest number. If you see #VALUE! or #NUM! in the cell instead, the range probably contains text where numbers should be, or the cells are formatted as text rather than numbers.

Find which row or cell contains the lowest number

MIN tells you what the lowest number is, but not where it lives. To find the row, use MATCH inside an INDEX function. This combination searches for the lowest value and returns the cell location.

The formula looks like this: =INDEX(A1:A50,MATCH(MIN(A1:A50),A1:A50,0)). MATCH finds where the lowest number sits in the range, and INDEX returns the cell address or the value in that cell, depending on how you set it up. Type this into an empty cell and press Enter.

If the lowest number appears more than once in your data, INDEX and MATCH return the first occurrence. If you need to find every cell with the lowest value, you will need to filter or sort the data instead.

Search across multiple sheets at once

If your data lives on more than one sheet, you can still use MIN to find the lowest number across all of them. Type the sheet name, an exclamation point, and the range: =MIN(Sheet1!A1:A50,Sheet2!A1:A50). Google Sheets searches both ranges and returns the single lowest value.

You can add as many sheets as you need by separating each range with a comma. This works whether the sheets are in the same file or different files, though different files require you to paste the full file link into the formula.

Troubleshoot when MIN returns an error

If MIN shows #VALUE!, the range contains text formatted as numbers, or numbers stored as text. Click on one of the cells in your range and look at the formula bar at the top — if the number is left-aligned instead of right-aligned, it is stored as text. Select the range, go to Format menu, choose Number, and pick a number format like "Number" or "Currency" to fix it.

If MIN shows #NUM!, the range contains no numbers at all. Check that you typed the range correctly and that the cells actually hold numeric data.

If MIN returns 0 when you expected a different number, check whether your data includes zero values or negative numbers. MIN treats both as valid numbers and will return them if they are the lowest in the range.

Use MIN with filters and sorting as an alternative

If you only need to find the lowest number once and do not need a formula, you can sort your data instead. Click on the column header, go to the Data menu, and choose "Sort sheet A to Z" (for ascending order, which puts the lowest number first). The smallest value moves to the top row, and you can see it when ready.

Sorting changes the order of your entire sheet, which can scramble related data in other columns. Use this method only if your data is not dependent on row order, or if you are working with a copy.

Filtering is another option: go to Data menu, choose "Create a filter", then click the filter icon in the column header and select "Sort range (low to high)". This temporarily hides rows and shows the lowest values at the top without rearranging your actual data.

Frequently Asked Questions

Can MIN find the lowest number in a row instead of a column?

Yes. Type =MIN(A1:Z1) to search across row 1 from column A to Z. MIN works the same way whether you search horizontally or vertically.

What happens if I use MIN on a range with negative numbers?

MIN returns the most negative number as the lowest. If your range is -5, -2, 0, 3, MIN returns -5. This is the correct behavior for most uses, but double-check your data if the result seems wrong.

Can I use MIN to find the lowest number in a column that also has headers or labels?

Yes, but start your range below the header. If row 1 contains "Price" and numbers start in row 2, use =MIN(A2:A50) instead of =MIN(A1:A50). This prevents the text header from causing an error.

Does MIN work if some cells in the range are empty?

Yes. MIN ignores empty cells and searches only the cells that contain numbers. If all cells are empty, MIN returns 0.

How do I find the lowest number in a range that changes size?

Use =MIN(A:A) to search the entire column A, or =MIN(A2:A) to search from row 2 down. Google Sheets automatically includes any new numbers you add to that column without requiring you to update the formula.