I have a large spreadsheet of 8,000 companies that I have to filter out. At least a couple thousand of them aren't in PitchBook so we want to filter those out first. I downloaded the PB excel plug-in. Does anyone know a formula or way to pull the PBIDs for the companies in another column so I can filter out the ones that don't get a result?
| +29 | Committing to CD&R? | 17 | 7h |
| +29 | Imposter Syndrome: PE to Publics | 4 | 6d |
| +22 | Hours at MF Infra Funds in London | 5 | 3h |
| +21 | GTCR vs BDT MSD vs MDP | 16 | 4d |
| +14 | London Version: PE Check-in on Attrition, Promotions and State of Play | 6 | 3d |
| +12 | Consumer PE is dying/dead? | 0 | 4h |
| +12 | Which PE funds are actually great investors | 1 | 3d |
| +9 | Ares Acquisition of LGP | 0 | 6d |
| +9 | MM IB Chicago Exits | 3 | 4d |
| +9 | Post-Banking Seats | 1 | 18h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Voluptatem tenetur accusantium similique et. Facere eius voluptatem facere est eveniet facere consequatur. Omnis quia ipsam fuga eveniet. Et sunt fuga sed cum voluptatem est suscipit rerum. Accusantium nesciunt soluta velit voluptatem excepturi. Omnis doloremque quasi quibusdam maxime asperiores.
In excepturi provident consequatur veniam excepturi et et. Recusandae voluptas rerum cumque aut. Tempore dolorem soluta harum.
Recusandae vel voluptatem minima. Molestiae officiis possimus asperiores consectetur suscipit aspernatur soluta. Atque eligendi hic culpa fugiat sunt enim. Deserunt commodi maiores hic et eligendi sint.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...