|
#1
|
|||
|
|||
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!!! |
#2
|
|||
|
|||
Re: Need an Excel Guru - Quick Question
OK, answered my own question now:
Data->Consolidate |
|
|