View Single Post
  #1  
Old 12-02-2005, 07:18 AM
stigmata stigmata is offline
Senior Member
 
Join Date: Aug 2004
Location: UK
Posts: 118
Default Need an Excel Guru - Quick Question

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!!!
Reply With Quote