count number of element

Originally Posted by NBVC

Have a look at Sumif() function in Excel help files.

e.g. In D1 enter, =Sumif($A$1:A$4,C1,$B$1:$B$4)

where A1:B4 contain your original data and C1 contains the first name to sum up for...

copy formula down.

You had solved half of my problem, thank you very much!
Do you know how can I obtain automatically column C without using data / filter / advanced filter / ...unique records only ?
For input I have only column A,B and I need to obtain column C,D.

well the simple way with no formulas would be to use a pivot table, iit could then increase if other names were added.

Or if it is just data for the 3 people to be added, make the ranges longer.

The first answer, is exactly how I would have answered your question, so perhaps you may need to explain a little more

Regards

Dav

A---------B----C---------D

john------2----john-------7
rick-------1----rick-------1
andrew---3----andrew----3
john------5

For input I have column A and B.
For output I need column C and D
NBVC had told me that I can use SUMIF function for column D, and it's working.
I don't know how can I obtain column C !
In column A I have "john" two times, with 2 and 5 elements. Rick and andrew it's only one tine each in column A.
Thanks a lot for answering me!

Thanks a lot!