9.4 Count number of repetitions of simple members

 

Here below a data table of names:

imagepng

To count the number of duplicate names, enter the formula in cell B2:

=spl("=?1.conj().select(~==?2).count()",A$2:A$6,A2)

Then drag B2 down to every relevant row:
imagepng


https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1655595805465
https://c.scudata.com/article/1655692490493