sum and listing

[Andreas5516]

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

 

[Don Guillett]

have a look in HELP index for COUNTIF

 

[Dave Peterson]

Debra Dalgleish has some nice counting/summing instructions at:

http://www.contextures.com/xlFunctions01.html
and
http://www.contextures.com/xlFunctions04.html