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!!! |
Re: Need an Excel Guru - Quick Question
OK, answered my own question now:
Data->Consolidate |
All times are GMT -4. The time now is 11:46 AM. |
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.