Skip to content

How to Write LARGE and SMALL (Build It Automatically, Free)

Published: Oct 19, 2026 | Updated: Oct 19, 2026 | About (Japanese)

Key points

Enter the range
Enter the rank
Copy the formula

LARGE SMALL Builder builds the formula from what you enter.

Steps

Enter the range
Enter the rank
Copy the formula

The formula can be pasted straight into a cell.

Use "Build a LARGE and SMALL Formula" (free)

Tools that go well with this

Build a Rank Formula: Build rank formulas.
Build a SUMIF or COUNTIF Formula: Build SUMIF and COUNTIF formulas.
Build a SUMPRODUCT Formula: Build SUMPRODUCT formulas.

If this guide helped, a small tip would mean a lot.

Send a tip (¥300)Send a gift (Amazon wishlist)

More guides for this tool