There are two ways:

1. Use Countif. As in =Countif(A:A,a1)

2. To get a summary of the names with their counts, the best way is to
create a pivot table. Post back if you need help on this.

Regards,
Fred

"Roshlin" wrote in message
...
Hi friends,

I have 6 columns with 100 names, I would like to count how many the names
appear in the differnt columns and have the results on the same or
another
sheet with the number of times the name repeates
eg.
Paul 4
Mike 3
Sandy 2
and so on,

Thanks for your help