Tallying a column of random numbers

Occasional Visitor

I have a long column of random numbers from 1-126. Most of those numbers occur multiple times. Some don’t occur at all. I don’t know which. Is there a quick way of tallying up how many times each number occurs?

How many 1’s, 2’s, 3’s etc

Thanks a million
2 Replies

Perhaps build helper range with numbers from 1 to 126 and COUNTIF your range on it.


Pivot Table even faster, but it won't show missed numbers.



Collegue above me was right! Attached in screenshot an example for you :) Greets, Eva.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies