people assigned to a project - how to know who to go to for each?

djveed

New Member
Joined
Nov 18, 2014
Messages
14
Hi everyone! I have a list of programs and for each of them, a list of names that worked on the program, anywhere between one and four people. If I want to synthesize this data and know, for example, what programs should i ask "Geoff" about, how do I do this in Excel?


ProgramPerson APerson BPerson CPerson D
Program CNBCAngela Geoff
Program CNNAshley Shelby Geoff
Program ZTVAshley Shelby Angela Chris
Program ESPNGeoff James
Program FoxAshley Shelby Chris

<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,497
something ike this?

ValueProgram
AngelaProgram CNBC, Program ZTV
GeoffProgram CNBC, Program CNN, Program ESPN
AshleyProgram CNN, Program ZTV, Program Fox
ShelbyProgram CNN, Program ZTV, Program Fox
ChrisProgram ZTV, Program Fox
JamesProgram ESPN
 

djveed

New Member
Joined
Nov 18, 2014
Messages
14
Yes! Something like that. How do I do that in Excel? Obviously I have far more than the six names listed in my data file.
 

djveed

New Member
Joined
Nov 18, 2014
Messages
14

ADVERTISEMENT

are you able to use PowerQuery (Get&Transform) ?
Actually I'm not totally sure. I'm pretty sure I have access to that but I've never used it.
 

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,497
Excel 2010/2013 - PowerQuery add-in
Excel 2016 and higher - built-in aka Get&Transform
 

djveed

New Member
Joined
Nov 18, 2014
Messages
14

ADVERTISEMENT

Okay. I may not actually have access to that add-in. Can you help me with this? My data file is only 20 Projects long.
 

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,497
you can download PowerQuery add-in from MS site, it's free
if not - I can't help

if you want use PQ you must have this add-in, if not you must wait for someone else with another solution
 
Last edited:

djveed

New Member
Joined
Nov 18, 2014
Messages
14
Thank you! Let me try this. If this doesn't work - is there any way to do this without the add-in? Anyone know?
 

sandy666

Banned - Rules violations
Joined
Oct 24, 2015
Messages
7,497
you are welcome

and yes, upgrade your office to minimum 2016 :)
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,651
Messages
5,838,584
Members
430,557
Latest member
MK15

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top