Hi:
I have a worksheet with two columns and multiple rows. Column 1 has Names
and column 2 has salary.
Charles 15
John 20
John 15
Peter 50

I woul like to see (end result) something like this (note duplicate gone but
salary summed up)

Charles 15
John 35
Peter 50


Thank You Regards Charles

In C1: =A1
C2: IF(ISERROR(MATCH(0,COUNTIF(C$1:C1,$A$1:$A$20&""),0 )),"",
INDEX(IF(ISBLANK($A$1:$A$20),"",$A$1:$A$20),MATCH( 0,COUNTIF(C$1:C1,$A$1:$A$20&""),0)))

which is an array formula so commit with Ctrl-Shift-Enter, not just Enter.
Copy C2 as far as you need.

D1:=IF(C1="","",SUMIF(A:A,C1,B:B)

and copy down

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Charles" wrote in message
...
Hi:
I have a worksheet with two columns and multiple rows. Column 1 has Names
and column 2 has salary.
Charles 15
John 20
John 15
Peter 50

I woul like to see (end result) something like this (note duplicate gone
but
salary summed up)

Charles 15
John 35
Peter 50


Thank You Regards Charles