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 many of the same number are repeated in the Column. I have tried a count if but does not appear to work.

Any ideas of the best way to count how many duplicates ,as I have as a very long list?

Many Thanks

Leicester Fox

 

[Fluff13]

Cross posted
Please read the rules https://chandoo.org/forum/threads/site-rules-new-users-please-read.294/

 

[Peter Bartholomew]

I don't see the problem.
=COUNTIFS(numbers, numbers )
If you have a list of unique occurrences, then
= COUNTIFS(numberArray, unique)
will give a more compact presentation without duplicate information.
The dynamic array formula for a sorted unique list is
=SORT(UNIQUE(numbers))
but this can also be achieved manually from the Data tab by using Remove Duplicates.

 

[Leicester City Fox]

Hi Peter

I am very grateful for you time

Thank you

Leicester Fox

 

[Leicester City Fox]

Cross posted
Please read the rules https://chandoo.org/forum/threads/site-rules-new-users-please-read.294/

Hi There

I am just asking a question it shouldn't matter the people I ask or the forum.... Always remember to spend more time to be respectful to all the people in the world

Thank You

Leicester Fox

 

[shrivallabha]

@Leicester City Fox

Fluff13 isn't wrong in pointing out the cross-posting. Have you read below link before? If not then please go through it.
https://www.excelguru.ca/content.php?184

This forum is quite lenient on forum cross-posting but some other forums are not so it is good to be aware!