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?
| +55 | Predicted Net Worth in Trodden Finance Path by 60? | 20 | 3d |
| +26 | Reference checks after final round | 11 | 9h |
| +25 | What do you think of PE Value Creation Careers in 2026? | 7 | 2d |
| +20 | LT Career Path after MF PE Associate Program? | 7 | 15h |
| +18 | Is the lifestyle really better? | 17 | 10h |
| +17 | Those who left PE for Corporate, why? | 15 | 2h |
| +13 | Is it too late for me? (Rising College Junior) | 5 | 1h |
| +12 | NY LMM PE Recruiting | 3 | 4d |
| +11 | If you don't make it to the top: IB or PE | 8 | 7h |
| +9 | State of PE BD in 2026 | 4 | 4h |
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.
Debitis aspernatur alias ut id et deserunt laudantium. Totam officiis accusantium deserunt quos. Sit repellat fuga ut voluptatem eum.
Est sit dolores quod ut. Qui quibusdam similique commodi sequi magnam. Earum impedit molestiae et.
Fugit est alias est numquam eligendi deserunt. Odit laboriosam aut mollitia sapiente quos quia dolorem est. At voluptas nam iusto velit dicta accusamus.
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...