sum and listing
 

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

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

Debra Dalgleish has some nice counting/summing instructions at:

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

Andreas5516 wrote:

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

--

Dave Peterson