Discussion Tallying a column of random numbers in Excel
https://techcommunity.microsoft.com/t5/excel/tallying-a-column-of-random-numbers/m-p/314187#M23927
Hi,<BR /><BR />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?<BR /><BR />How many 1’s, 2’s, 3’s etc<BR /><BR />Thanks a millionSat, 12 Jan 2019 22:16:26 GMT7brownjack2019-01-12T22:16:26ZTallying a column of random numbers
https://techcommunity.microsoft.com/t5/excel/tallying-a-column-of-random-numbers/m-p/314187#M23927
Hi,<BR /><BR />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?<BR /><BR />How many 1’s, 2’s, 3’s etc<BR /><BR />Thanks a millionSat, 12 Jan 2019 22:16:26 GMThttps://techcommunity.microsoft.com/t5/excel/tallying-a-column-of-random-numbers/m-p/314187#M239277brownjack2019-01-12T22:16:26ZRe: Tallying a column of random numbers
https://techcommunity.microsoft.com/t5/excel/tallying-a-column-of-random-numbers/m-p/314251#M23933
<P>Perhaps build helper range with numbers from 1 to 126 and COUNTIF your range on it.</P>
<P> </P>
<P>Pivot Table even faster, but it won't show missed numbers.</P>
<P> </P>Sun, 13 Jan 2019 13:46:02 GMThttps://techcommunity.microsoft.com/t5/excel/tallying-a-column-of-random-numbers/m-p/314251#M23933Sergei Baklan2019-01-13T13:46:02ZRe: Tallying a column of random numbers
https://techcommunity.microsoft.com/t5/excel/tallying-a-column-of-random-numbers/m-p/314257#M23937
<P>Hi!</P><P>Collegue above me was right! Attached in screenshot an example for you :) Greets, Eva.</P>Sun, 13 Jan 2019 14:14:59 GMThttps://techcommunity.microsoft.com/t5/excel/tallying-a-column-of-random-numbers/m-p/314257#M23937Eva Vogel2019-01-13T14:14:59Z