mrmmickle1
Well-known Member
- Joined
- May 11, 2012
- Messages
- 2,461
I have data that looks like this:
Is there a way for me to use a formula to pull in all values associated with a specific name...
For Example:
Excel 2012 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
D | E | F | G | H | I | J | K | L | |||
5 | Finalize performance of TWIST, VIM, NID, OTX1, ONECUT2; | Allan | |||||||||
6 | Assess IP landscape that would allow for methylation to be run on LC480s under MethyLight patent license (call Mike Rondelli) | Jeff | |||||||||
7 | Assess sequence for possible primer/probe sites that would allow for CpG-agnostic amplification/hybridization | Allan | |||||||||
8 | |||||||||||
9 | 1 | ||||||||||
10 | develop strategy to assess CDKN2A INDELs by 2-3 <200bp multiplexed primer sets | Andrew | |||||||||
11 | demonstrate multiplexing with PIK3CA of either single 324 primer set or combination of <200 primer sets multiplexed | Andrew | |||||||||
12 | |||||||||||
13 | 1 | 1 | 2 | ||||||||
14 | Olivia | ||||||||||
15 | |||||||||||
16 | 1 | 1 | 2 | ||||||||
17 | SubTask | Olivia | |||||||||
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 | ||||||
---|---|---|---|---|---|---|
L | M | N | O | |||
5 | Allan | Jeff | Andrew | Olivia | ||
6 | Finalize 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 sets | SubTask | ||
7 | Assess sequence for possible primer/probe sites that would allow for CpG-agnostic amplification/hybridization | demonstrate multiplexing with PIK3CA of either single 324 primer set or combination of <200 primer sets multiplexed | ||||
Master List |