Forum Discussion
Tallying a column of random numbers
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
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
Hi!
Collegue above me was right! Attached in screenshot an example for you :) Greets, Eva.
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.
