Hi guys,
Really hope one of you guys have a little time to help an excel newbie in his way of becoming an excel champion.
What I want to do is:
(A) and (B) is connected in rows and the value of each row is placed in (C) as a number.
However in column (A) and (B) there are a bunch of duplicates.
How can I remove duplicates but in the same time combine the sum the values of (C).
Example:
(A) (B) (C)
1231 Something 1
1231 Something 3
1244 SometingElse 1
1231 Something 1
Output should be:
(A) (B) (C)
1231 Something 5
1244 SometingElse 1
Bookmarks