Two Plus Two Older Archives  

Go Back   Two Plus Two Older Archives > General Gambling > Computer Technical Help
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 12-02-2005, 09:37 AM
stigmata stigmata is offline
Senior Member
 
Join Date: Aug 2004
Location: UK
Posts: 118
Default Re: Need an Excel Guru - Quick Question

OK, answered my own question now:

Data->Consolidate
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 03:35 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.