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?
| +110 | Is Everyone Too Bearish on PE? | 34 | 1d |
| +48 | Why would anyone do PE in long term in 2026? | 13 | 2d |
| +43 | MF Tech PE 2026 | 16 | 2h |
| +25 | Q&A: What It’s Actually Like Working at an Independent (Fundless) Sponsor | 4 | 4d |
| +24 | Do you think PE has actually helped you become a better entrepreneur? | 8 | 1d |
| +22 | Best Finance Clubs at UC Berkeley for IB/PE? | 4 | 4h |
| +21 | UMM PE or High Paying Strat Finance? | 13 | 2d |
| +18 | Moving from LevFin / Private Credit to PE Buyout – How to Position My CV? | 1 | 6h |
| +16 | Portfolio Marks | 8 | 1d |
| +15 | DELETE | 1 | 3d |
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.
Et neque illum est quo dolore. Temporibus vel sit voluptatem accusantium. Voluptas aliquid velit et atque natus fugiat illum.
Rerum in sint consequatur aspernatur velit adipisci eligendi. Est natus voluptas cupiditate labore molestiae. Quia nihil quisquam et mollitia nobis assumenda quibusdam quae. A rerum incidunt debitis a odio necessitatibus placeat.
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...