Here below is a personnel data table:

To count the number of duplicate data (the judging basis is that the data in the Name field are the same), enter the formula in the cell E2:

=spl("=?1.conj().select(~==?2).count()",B$2:B$7,B2)

Then drag E2 down to every relevant row:

https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1655692438816
https://c.scudata.com/article/1655777408703