Array Formula to Pull in All Values Related to Certain Employee

mrmmickle1

Well-known Member
Joined
May 11, 2012
Messages
2,461
I have data that looks like this:


Excel 2012
DEFGHIJKL
5Finalize performance of TWIST, VIM, NID, OTX1, ONECUT2;Allan
6Assess IP landscape that would allow for methylation to be run on LC480s under MethyLight patent license (call Mike Rondelli)Jeff
7Assess sequence for possible primer/probe sites that would allow for CpG-agnostic amplification/hybridizationAllan
8
91
10develop strategy to assess CDKN2A INDELs by 2-3 <200bp multiplexed primer setsAndrew
11demonstrate multiplexing with PIK3CA of either single 324 primer set or combination of <200 primer sets multiplexedAndrew
12
13112
14Olivia
15
16112
17SubTaskOlivia
Master List


Is there a way for me to use a formula to pull in all values associated with a specific name...

For Example:


Excel 2012
LMNO
5AllanJeffAndrewOlivia
6Finalize performance of TWIST, VIM, NID, OTX1, ONECUT2;Assess IP landscape that would allow for methylation to be run on LC480s under MethyLight patent license (call Mike Rondelli)develop strategy to assess CDKN2A INDELs by 2-3 <200bp multiplexed primer setsSubTask
7Assess sequence for possible primer/probe sites that would allow for CpG-agnostic amplification/hybridizationdemonstrate multiplexing with PIK3CA of either single 324 primer set or combination of <200 primer sets multiplexed
Master List
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Forum statistics

Threads
1,214,628
Messages
6,120,618
Members
448,973
Latest member
ChristineC

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
Back
Top