Formula to find out same names from in xls sheet

Hi, welcome to the forum :0

Not really sure what you are asking here, so this is a shot in the dark.

If you want to just count the number f times a name appears...
=COUNTIF($Q$6:$Q$778,Q6)

If you want to get fancy, then...
=Q6&" Appears "&COUNTIF($Q$6:Q6,Q6)& " times"

If this is not what you wanted, please provide a few sample answers

Thanks for your reply FDibbins

I want to find out the reparations of names entered in list. I want it's total count or highlighted in the list.

for example I highlighted some names in list.

Originally Posted by FDibbins

If this is not what you wanted, please provide a few sample answers

Perhaps you missed this part?