PDA

View Full Version : Need an Excel Guru - Quick Question


stigmata
12-02-2005, 07:18 AM
So I have 3 lists that look something like this:

List 1:
Alex 5
Bob 8
David 7
Sarah 6
Zog 11

List 2:
Alex 3
Brian 5
David 7
Emily 9
Sarah 4
Zog 8

List 3:
Brian 9
David 4
Emily 1
Sarah 2
Steve 7
Zog 2

So some of the names appear in all 3 lists, some just in 1 list. I want a single list, with all the results next to each name. E.g. I want a list like this:
List All:
Alex 5 3
Bob 8
Brian 5 9
David 7 7 4
Emily 9 1
Sarah 6 4 2
Zog 11 8 2

Thanks!!!

stigmata
12-02-2005, 09:37 AM
OK, answered my own question now:

Data->Consolidate