I have a list of about 300 names and "points" in an excel spreadsheet. Each day I have to add more "points" to these existing names. For example, the list below would be 6 of the 300 names that exist. Lets say Mike has acummulated 15 more "points". What I am having to do now is hand enter the 15 points into the cell that contains Mikes 133 points. This would be =sum(133+15) in the cell for Mike's points. What I'd like to do is have excel recognize that Mike already has 133 points and auto add the 15 new points based on name recognition.
Name Points
Bob 155
Todd 122
Mike 133
Jennifer 100
Vince 34
Tim 122
My question is if i have a list like this:
Name Points
Bob 155
Todd 122
Mike 133
Mike 15
Jennifer 100
Vince 34
Tim 122
Could i highlight the entire data and have the point totals for Mike consolidated and added under one name like this:
Name Points
Bob 155
Todd 122
Mike 148
Jennifer 100
Vince 34
Tim 122
Hope this question makes sense.
Bookmarks