Question about Excel

[pravi333]

I have a column with about 100 rows, each cell value is a random number between 1 and 100. Is it possible in excel to figure out how many 1's, 2's, 3's,... and 100's are there in those 100 rows?

 

[Snapster]

// Count how many instances of the number 1

=COUNTIF($A$1:$A$100, 1)

// Count how many instances of the number 2

=COUNTIF($A$1:$A$100, 2)

etc

 

[pravi333]

Originally posted by: Snapster
// Count how many instances of the number 1

=COUNTIF($A$1:$A$100, 1)

// Count how many instances of the number 2

=COUNTIF($A$1:$A$100, 2)

etc

Cool! thank you!