have a look in HELP index for COUNTIF

--
Don Guillett
SalesAid Software

"Andreas5516" wrote in message
m...
Hello

Is it possible to have Excel list and sum the following data in column A:

ben
john
ben
ben
john

Into:

ben 3
John 2

In two new columns?

/Andreas