Formula or Macro for counting duplicates

Hi all,

Can some one help to find solution for this.
I need formula or macro for finding duplicates and counting it.
Here is the file.

https://www.dropbox.com/s/p35a31mx5y...cate.xlsx?dl=0

Now I count it manually, bold text below each column.

Thanks,

Please post file to this forum as many respondents do not access file-hosting sites..

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Ok, thanks for explaining how to attach file

This formula will give you list of unique values in column A

in A51

=IFERROR(INDEX(A$2:A$39, MATCH(0, IF(ISBLANK(A$2:$A$39), 1, COUNTIF(A$50:$A50, $A$2:$A$39)), 0)),"")

Enter with Ctrl+Shift+enter and then copy down

in A55

=COUNTIFS($A$2:$A$48,A51)

Count of ID in A51

Copy down

You can use the above to create a table with 1st, 2nd etc in paired columns