I have a spreadsheet for keeping scores in a local sports league. In cell A1 I have the number of league points for the match and in B1 I have the Team name. Each row is a match result. So I get
Points Team
3 Aztecs
1 University
1 Aztecs
etc
I want to scan the column to find the team name, then add the points value to another cell so it will show the number of league points a team has.
So in the example the league table will be
Points Team
4 Aztecs
1 University
Can this be done ?
Thanks in anticipation
the.gnome
