how to sum contents of duplicate rows
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
|