ExcelBanter - Repetitive Numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Repetitive Numbers (https://www.excelbanter.com/excel-discussion-misc-queries/131338-repetitive-numbers.html)

Katelyn

Repetitive Numbers

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

Thanks

Toppers

Repetitive Numbers

=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

All times are GMT +1. The time now is 05:48 AM.