I want to count No .of same names in work sheet

[Max]

First ... you should never leave the message area blank in your posting. The
subject line is just that. It's not meant to be the posting. Always
elaborate on your post in the message area.

Ok, here's one quick way to drive it out ... use a pivot table (PT)

Assume the names are listed down in one col, with a top col header, viz.:

Name < assume this is the col header
Name1
Name1
Name2
Name3
Name2
etc

Select the col
Click Data > Pivot table
Click Next > Next

In step 3 of the wiz. click Layout
Drag n drop Name within the ROW area
Drag n drop Name within the DATA area
(It'll appear as Count of Name)
Click OK > Finish. That's it.

Hop over to the PT sheet for the results ..
It will look like this:

Count of Name
Name Total
Name1 2
Name2 2
Name3 1
Grand Total 5

The pivot table will return both a unique listing of names and their
corresponding counts

 

[Bob Phillips]

Tad short on details

=COUNTIF(A:C,"the name")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)