Every cattle drive had a day herder whose job was to sit on a rise, keep watch over the herd, and answer one question at a time. Is there a runt falling behind? Which steer strayed farthest from the group? One question, one answer. That's exactly how many Excel functions work — you ask a single question, and Excel rides back with a single number. Here are two examples: MIN and MAX.
MIN: Spotting the Runt of the Herd
Finds the smallest value in a range.
- Click the cell where you want the result.
- Type =MIN( and select your range, such as B2:B50.
- Press Enter.
Outcome: You instantly know your lowest value — the smallest sale, the lowest score, the shortest wait time — without scanning the list yourself.
MAX: Spotting the Prize Bull
Finds the largest value in a range.
- Click the cell where you want the result.
- Type =MAX( and select your range, such as B2:B50.
- Press Enter.
Outcome: You immediately see your top performer — the biggest sale, the highest score, the longest-tenured employee — with zero manual searching.
MIN and MAX are great day herders. But what if you don't want just one animal — what if you want to identify an entire group that matches a certain description. That's where a spill function like FILTER comes in. Instead of riding back with a single answer, FILTER cuts out every matching row and spills the whole cut into the cells nearby — the same way cowboys at a roundup used a trained cutting horse to separate cattle by brand from a mixed herd. (No cutting and pasting required — Excel, like a good herder, grabs the ones you need, automatically.)
FILTER: Cutting Out the Ones You Need
Returns every row that matches a condition, not just one value.
- Click the cell where you want the results to spill. Make sure there are plenty of empty cells to the right and below it — FILTER needs room to spill its results, and if existing data is in the way, you'll get a #SPILL! error.
- Type =FILTER( followed by the range you want returned, a comma, then the condition. For example: =FILTER(A2:C50, B2:B50>1000).
- Press Enter.
Outcome: Instead of one number, you get an entire list — every sale over $1,000. Similarly, you can apply the FILTER function to get every student who passed, every order still pending — each spilled automatically into as many cells as needed.
MIN and MAX send back a single day herder's report. FILTER cuts out the portion of the herd that matches. Knowing when you need one answer versus when you need a cut of the herd is what separates a casual Excel user from someone who can really put their spreadsheet to work.
Want help putting functions like FILTER to work in your own spreadsheets? Reach out to us and let us know what you're working on.
