Spreadsheet: 760572d1640305528-analysis-of-name-combinations-find-words-in-strings-table
Sheet: Sheet1

 |  | column J - how can I analzye how many times a combination of 2 names appears in each cell from a list of 10 names. So let's say the list of 10 names I care about relationships are: Janus, [NAME], Vivo, BVF, Fidelity, Cormorant, Perceptive, Wellington, [NAME], [NAME] and I want to know where they seem to do things together - then the output would tell me that Janus and Perceptive appear X amount of times together. I am trying to capture if there are ones who appear to be together more than others.
 |  |  |  |  |  |  |  |  | Janus, [NAME], Vivo, BVF, Fidelity, Cormorant, Perceptive, Wellington, [NAME], Adage
 |  |  |  |  |  |  |  |  | Meritech Capital Partners; Paladin Capital Group; SoftBank Capital; Fidelity Management & Research Company LLC; BVF; Wells Fargo Strategic Capital
 |  |  |  |  |  |  |  |  | [NAME], LLC; Perceptive Advisors LLC; Cystic Fibrosis Foundation; Viking Global Investors LP; BVF Partners, L.P.; Pfizer Venture Investments LLC; Mirae Asset Financial Group; Ridgeback Capital Management, LLC; ArrowMark Colorado Holdings, LLC; Casdin Capital, LLC; Chiesi Ventures; Octagon Investments LLC; Amzak Health Investors, Llc; Longevity Vision Investment Advisors, LLC; Berkeley Catalyst Fund Management LLC; Quad Investment Management Corp., Investment Arm
 |  |  |  |  |  |  |  |  | Polaris Venture Partners, Inc.; OrbiMed Advisors LLC; Federated Hermes, Inc.; Fidelity Management & Research Company LLC; RA Capital Management, L.P.; Polaris Venture Partners V, L.P.; [NAME]; Redmile Group, LLC; Premji Invest Limited; GV Management Company, LLC; Omega Fund Management, LLC; ArrowMark Colorado Holdings, LLC; Foresite Capital Management, LLC; Mithril Capital Management LLC; Polaris Venture Partners Entrepreneurs Fund V, L.P.; Polaris Venture Partners Founders Fund V, L.P.; Polaris Venture Partners SPECIAL Founders Fund V, L.P.; Mithril II LP; Polaris Partners IX, L.P.; Bain Capital Life Sciences Investors, LLC; Polaris Healthcare Technology Opportunities Fund, L.P.; Population Health Partners, LLC
 |  |  |  |  |  |  |  |  | Atlas Venture L.P.; Sofinnova Investment, Inc.; Citadel Advisors LLC; Citadel Multi-Strategy Equities Master Fund Ltd.; Cormorant Asset Management, LP; Osage University Partners
 |  |  |  |  |  |  |  |  | Atlas Venture L.P.; Versant Venture Management, LLC; Apple Tree Partners; BVF Partners, L.P.; Redmile Group, LLC; venBio LLC; Boxer Capital LLC; Cormorant Asset Management, LP; Rock Springs Capital Management LP; Janus Henderson Investors; LifeSci Venture Partners
 |  |  |  |  |  |  |  |  | New Enterprise Associates, Inc.; Novartis Venture Funds; Sofinnova Investment, Inc.; 5AM Venture Management, LLC; Fidelity Management & Research Company LLC; RA Capital Management, L.P.; Mass General [NAME], LLC; Citadel Advisors LLC; Citadel Multi-Strategy Equities Master Fund Ltd.; Cormorant Asset Management, LP; EcoR1 Capital, LLC; [NAME]; Pivotal BioVenture Partners LLC; CHI Advisors LLC; Polaris Founders Capital; PagsGroup
 |  |  |  |  |  |  |  |  | Agilent Technologies, Inc.; Telegraph Hill Partners; PJC Capital Management LLC; Innovatus Capital Partners, LLC
 |  |  |  |  |  |  |  |  | Polaris Venture Partners, Inc.; OrbiMed Advisors LLC; SV Health Investors, LLC; Perceptive Advisors LLC; Deerfield Management Company, L.P.; Amgen Ventures; Amgen Ventures, L.P.; New Leaf Venture Partners, LLC; Eli Lilly Investment Consulting (Shanghai) Co., Ltd.; GV Management Company, LLC; Mission Bay Capital LLC; AbbVie Ventures, Inc.; Casdin Capital, LLC; M Ventures; MRL Ventures Fund; Foresite Capital Management, LLC; Dementia Discovery LP; Euclidean Capital LLC; Section 32, LLC
 |  |  |  |  |  |  |  |  | Vivo Capital, LLC; Versant Venture Management, LLC; Wellington Management Group LLP; Novo Holdings A/S; Janus Henderson Group plc; Roche Venture Fund; Logos Capital Management, LLC; Boxer Capital LLC; Cormorant Asset Management, LP; Pivotal BioVenture Partners LLC
 |  |  |  |  |  |  |  |  | Gilead Sciences, Inc.; Fidelity Management & Research Company LLC; Redmile Group, LLC; EcoR1 Capital, LLC; Samsara BioCapital LLC; F2 Capital Ventures LLP
 |  |  |  |  |  |  |  |  | NA
 |  |  |  |  |  |  |  |  | Vivo Capital, LLC; HBM Healthcare Investments AG; Janus Henderson Group plc; BVF Partners, L.P.; HBM Partners Ltd.; venBio LLC; Foresite Capital Management, LLC; LSV Capital Management, LLC; Cormorant Asset Management, LP; Logos Global Management, L.P.
 |  |  |  |  |  |  |  |  | NA
 |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  | New Enterprise Associates, Inc.; Farallon Capital Management, L.L.C.; Janus Capital Management LLC; BlackRock, Inc.; Deerfield Management Company, L.P.; Adage Capital Management, L.P.; Adage Capital Partners, L.P.; [NAME], LP; BlackRock Health Sciences Trust; Blackstone Life Sciences; Global Funds Management S.A.; Janus Global Life Sciences Fund; BlackRock Global Funds - World Healthscience Fund; BlackRock Funds - BlackRock Health Sciences Opportunities Portfolio; Blackrock Capital Management Inc.; Bain Capital Private Equity, LP; Redmile Group, LLC; Citadel Advisors LLC; BlackRock (Luxembourg) S.A.; Eventide Asset Management, LLC; Citadel Multi-Strategy Equities Master Fund Ltd.; Mutual Fund Series Trust; Mutual Fund Series Trust - Eventide Healthcare & Life Sciences Fund; BlackRock Health Sciences Master Unit Trust; Satter Investment Management, LLC; Clarus Lifesciences III, L.P.; New Enterprise Associates 15, L.P.; Bain Capital Life Sciences Fund, L.P.; Deerfield Private Design Fund IV, L.P.; Satter Medical Technology Partners, L.P.; The Satter Foundation; Redmile Biopharma Investments II, L.P.; Bain Capital Life Sciences Investors, LLC; Janus Henderson Biotech Innovation Master Fund Limited; Nea Ventures 2016, L.P.