Tallying a column of random numbers

Highlighted
Occasional Visitor
Hi,

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.

 

Highlighted

Hi!

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