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

HTH

"Katelyn" wrote:

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

Thanks