Hi all,
How do I merge two rows in which the information in all columns except one is the same? Please refer to attachment. You can see in Column A to Column C that the information is the same for each player, but in Column D the points is different for each player. If I remove duplicates then I will essentially erase the second (and third, and fourth) entry of the player. Is there a way to merge and add-up the points column of each player?
Say for example, in the spreadsheet there are three rows of Kyle (Rows 2 to 4), but the amount of points he scored (column D) for each row is different. Is there a formula that can help me add the points column under each row together and for duplicates of all other players as well?
Of course I could do this manually but if the spreadsheet is 1000 players long then it will be super impractical. So is there a formula to achieve the effect mentioned above?
Bookmarks