Repetitive Numbers

[Katelyn]

Is there a way Excel 2003 can see repetitive numbers and calculate how many
of them there are?

Thanks

 

[Toppers]

=COUNTIF(A:A,1) will count number of 1s in column A

HTH