Count formula for duplicates

[willow1985]

Hello,

I am looking for a count formula for duplicates. For example:

In column A I have invoice numbers:

Column A

Row1 10001
Row2 10002
Row3 10005
Row4 10001
Row5 10003
Row6 10001

I want to enter a formula in F1 that will take the value in A1 and find how many duplicates of that value are in the entire A column, for example the formula in this case would return: 3. I believe this might be some form of index match but I was hoping for some help on it.

Thank you very much!

Carla

 

[Fluff]

How about
=countif(A:A,A1)

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...nting-all-occurrences-column.html#post5341510

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).