Small Function

Hi Excel pros! I am trying to update a spreadsheet for the new year by coping one that was used last year (2023) In the results sheet however, the result for the SMALL formula is coming up #NUM!...

Excel

Formulas and Functions

Rodrigo_
Jan 03, 2024
JenniL0211
you can use the MIN function to find the smallest date between two cells. If you want to find the smallest date between cell D2 on two different sheets (let’s say “Sheet2” and “Sheet3”), you can use the following formula in cell D2 on your master sheet:
=MIN(Sheet2!D2, Sheet3!D2)
The formula above will return the earliest date between the two cells. If one or both of the cells are empty or do not contain a date, the formula will return #NUM!. To avoid this, you can modify the formula to ignore non-date values:
=MIN(IF(ISNUMBER(Sheet2!D2), Sheet2!D2, ""), IF(ISNUMBER(Sheet3!D2), Sheet3!D2, ""))

Rodrigo_

Steel Contributor

Jan 03, 2024

JenniL0211
you can use the MIN function to find the smallest date between two cells. If you want to find the smallest date between cell D2 on two different sheets (let’s say “Sheet2” and “Sheet3”), you can use the following formula in cell D2 on your master sheet:

=MIN(Sheet2!D2, Sheet3!D2)

The formula above will return the earliest date between the two cells. If one or both of the cells are empty or do not contain a date, the formula will return #NUM!. To avoid this, you can modify the formula to ignore non-date values:

=MIN(IF(ISNUMBER(Sheet2!D2), Sheet2!D2, ""), IF(ISNUMBER(Sheet3!D2), Sheet3!D2, ""))

JenniL0211
Copper Contributor
Jan 12, 2024
Hi! Thank you so much for the explanation! The formulas worked perfectly and the explanation for the #NUM as much needed to explain to a supervisor LOL

Forum Discussion

Small Function

Share

Resources