counting how many of the same numbers

[Richard]

Help with formula please, I have a column of numbers lets say Sheet1 column
B2 and down. I want to count how many of the same number on Sheet2. Don't
know how to format Sheet2 to sepereate each number. Probably (Sheet2 A1, 1)
(Sheet2 B1, 2) (Sheet2 C1, 3) and so on up to 100. Then on Sheet2 A2 have the
results from Sheet1 as to how many from Sheet1. Thanks in advance.

 

[FSt1]

hi
once you decide how you going to layout sheet 2, on sheet 2 enter this formula
=countif(sheet1!B2:B100,1) this will count all 1's.
=countif(sheet1!B2:B100,2) this will count all 2's.
=countif(sheet1!B2:B100,3) this will count all 3's.

and so on.

regards
FSt1