How do I put numbers into ranges in Excel?

In plain Excel you write a nested IF() chain or a VLOOKUP with approximate match against a ranges table. Tellsheet's Bucketize / Bin Values does it in one step — supply cut points or a bin count and it writes a labelled Band column.

Can I choose the bin boundaries myself?

Yes. Enter your own ascending cut points, such as 18, 25, 40, 65, and each number is labelled by the band it falls into. Or ask for N equal-width bins and it splits the range for you.

Where does the result go?

A new Band column is written to a new sheet, so your source data is untouched. Pair it with Group & Summarize to count or total by band.

Home › Excel Guides › Bin Values

How to Bin or Bucket Numbers into Ranges in Excel

Turning a numeric column into labelled bands — age groups, price tiers, grade A/B/C — has no one-click button in Excel. You either write a nested IF() chain or maintain a lookup table by hand. Here's the way to bucketize a column with your own cut points, straight to a new sheet.

Last updated: August 2026

Age		Band (new column)
15	→	< 18
22	→	18–25
70	→	≥ 65

Why Excel makes this hard

Banding numbers means one of two chores. Either a long nested IF() chain — =IF(A2<18,"< 18",IF(A2<25,"18–25",…)) — that gets unreadable fast, or a VLOOKUP against a hand-built ranges table using approximate match, which silently returns the wrong band if the table isn't sorted ascending. Worse, every time the thresholds change you rebuild the whole thing. There's no one-click “bucket this column” in Excel.

The 1-click way — Tellsheet's Bucketize / Bin Values

Select the range and run Bucketize / Bin Values. Give your own ascending cut points like 18, 25, 40, 65 — or just a bin count for N equal-width bins — and it appends a labelled Band column on a new sheet, leaving your source data untouched. It's deterministic: same input, same bands, no AI. Pairs neatly with Group & Summarize (band first, then summarize by the band) and Rank.

Frequently asked questions

How do I put numbers into ranges?

Give Bucketize your cut points or a bin count and it writes a labelled Band column — no nested IF or lookup table.

Can I set the boundaries myself?

Yes — type ascending cut points like 18, 25, 40, 65, or ask for N equal-width bins.

Does it change my data?

No — the Band column lands on a new sheet, so the source stays as it was.

Can I count how many fall in each band?

Yes — band first, then run Group & Summarize on the Band column to count or total per band.

Related Excel guides

Bucket a column in one click

Bin Values turns a numeric column into labelled bands with your own cut points or a bin count — written to a new sheet, source untouched.

Get Tellsheet free See pricing