Request you to refer this similar topic for identifying if a value is repeated across a column and keep a count of the same.
Instead of just flagging the value as duplicate with TRUE/FALSE in adjacent column, you can also output count stating number of times a given value was found in the column.