Want to Count number Repeated numbers in a Column

[Leicester City Fox]

Hi There

I have a list of numbers in a Column and I have been asked to find out how manyof the same number are repeated in the Colum. I have tried a count if but doesnot appear to work.
Anyideas of the best way to count how many duplicates I have as the list is very long?

Many Thanks

LeicesterFox

 

[Special-K99]

With a list of numbers in column A

in B1
=IF(COUNTIF(A$1:A$1000,A1)>1,COUNTIF(A$1:A$1000,A1),"")
and copy down the column

Column B will tell you the number of times the A value occurs or it will be blank

 

[Fluff]

Cross posted https://chandoo.org/forum/threads/want-to-count-number-repeated-numbers-in-a-column.41503/

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Leicester City Fox]

Hi Moderator

You have understand there no law or rule stating you cat ask a question any forum.

Please be respectful to all members

Have a good day

Leicester Fox

 

[Leicester City Fox]

Hi Special-K99

Thanks for this its much appreciated

The Leicester Fox

 

[Fluff]

@Leicester City Fox
Please respect our members and rules.
That means that when you cross post you need to supply the relevant links
Thanks