Find the earliest date in a list
=MIN(B2:B9)Excel · result on the sample sheet: 3/8/2026
Describe what you need and get a working SMALL formula for Excel and Google Sheets, tested on real data before you copy it. SMALL returns the k-th smallest value in a range: k = 1 is the smallest, 2 the second smallest, and so on.
Each formula below was calculated on its own sample sheet. Open one to see the sheet, why it works, and to try it yourself.
=MIN(B2:B9)Excel · result on the sample sheet: 3/8/2026
=MINIFS(B2:B7,B2:B7,">="&E1)Excel · result on the sample sheet: 10/30/2026
=SUM(B2:F2)-MIN(B2:F2)Excel · result on the sample sheet: 5 rows (G2:G6)
=MAX(B2:B8)-MIN(B2:B8)Excel · result on the sample sheet: 22
=MINIFS(B2:B7,B2:B7,">0")Excel · result on the sample sheet: $22.50
=INDEX(FILTER(A2:A10,B2:B10=F1),H1)Excel · result on the sample sheet: 4/17/2026
=TRANSPOSE(FILTER(B2:B11,A2:A11=E1))Excel · result on the sample sheet: 1 row (E2:H2)
=FILTER(A2:A11,B2:B11=G1,"No orders")Excel · result on the sample sheet: 4 rows (G2:G5)
You describe the task in plain English, and it writes the formula, using SMALL where that's the right tool, for your table or a sample one. The formula is run in our engine in Excel and Google Sheets mode before you see it, so you get its result, not just a guess.
SMALL returns the k-th smallest value in a range: k = 1 is the smallest, 2 the second smallest, and so on.
Yes. Each example below opens a page where you try the formula in a live grid and it's checked as you go, and the SMALL function page has a practice exercise.