Hello,

There is no need to list (and later to keep track of) all your unique
entries/names.

I suggest to select a sufficiently long area of rows and two columns
and to array-enter:
=Pfreq(TRANSPOSE(returnnonempty(A1:I999)))

Pfreq is a UDF which you can find he
http://sulprobil.com/html/pfreq.html

ReturnNonEmpty you will find he
http://sulprobil.com/html/concatenate.html

A COUNTIF approach is suboptimal here and should only be used if you
cannot use VBA. Please see http://sulprobil.com/html/countif.html

Regards,
Bernd