How to Make a Frequency Table (or Histogram) in Excel
Turning a column into a value → count distribution is the analysis staple — how many Apples, how many orders in each price band. Excel makes you assemble it by hand every time. Here's the one-click way to tabulate any column to a new sheet, either by distinct value or as a number histogram.
Last updated: August 2026
| Fruit | Count (new sheet) | |
|---|---|---|
| Apple | → | 3 |
| Pear | → | 2 |
| Kiwi | → | 1 |
Why Excel makes this hard
Counting how often each value occurs sounds trivial, but Excel gives you three awkward routes. You can write a COUNTIF() for every distinct value — except you first have to list those values by hand, and you won't know them until you've scanned the column. You can build a pivot table, which works but you rebuild it every time the data changes. Or for numbers you can reach for the Analysis ToolPak Histogram, which needs a prepared bin range and produces a static block that doesn't refresh. There's simply no one-click "tabulate this column" button.
The 1-click way — Tellsheet's Frequency Table
Select the column and run Frequency Table. Pick "each distinct value" to count every unique entry, or "number bins (histogram)" to split the numeric range into equal-width bands and count each. Optionally add a percent-of-total column, and it writes a sorted Value / Count table to a new sheet — deterministic, with no formulas to maintain. Pairs with Bucketize / Bin Values and Group & Summarize.
Frequently asked questions
Do I have to list the values first?
No — that's the point. Frequency Table scans the column for you and lists every distinct value with its count, so there's no COUNTIF to write.
Can it bin numbers into a histogram?
Yes — pick "number bins (histogram)" and it splits the range into equal-width bands and counts each, no prepared bin range needed.
Can I get percentages too?
Yes — turn on the optional percent-of-total column and each row shows its share of the total beside the count.
Where does the result go?
To a new sheet, sorted, leaving your source column untouched. Re-run it any time the data changes.
Related Excel guides
Tabulate a column in one click
Frequency Table turns any column into a sorted value → count distribution on a new sheet — distinct values or number bins, with an optional percent column.
Get Tellsheet free See pricing