If I were to copy/paste a list of names and a list of scores and put the names from A1-A7 and numbers in B1-B7:
Alan 98
Bob 93
Chris 88
Dave 75
Eric 73
Fred 71
Greg 66
And then in C1-C7 list names and D1-D7 list new numbers:
Eric 100
Alan 99
Dave 95
Bob 88
Greg 77
Chris 74
Fred 63
Is there a way to 'match' the names and list them in order? so I can then just total their grades (adding B1 and D1 in this example). I realize in my example I can just list in alphabetical order, but is there a way to organize the names using another function?
Bookmarks