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?
| +43 | Those unemployed in PE 3+ months, how do you make progress every day? | 23 | 3h |
| +18 | Friend considering moving from the US to Hong Kong for an IR Role – How difficult would it be to return? | 1 | 19h |
| +17 | Is it possible to get no comments as an analyst? | 6 | 7h |
| +13 | How Cooked is Software PE? | 1 | 6d |
| +13 | London PE Secondaries / Co-Investment Comp | 4 | 15h |
| +12 | Indian PE Landscape | 2 | 5d |
| +9 | Arcline thoughts? | 7 | 2d |
| +9 | JPM PB to Institutional Capital Raising | 1 | 5d |
| +8 | Searchfund | 5 | 4d |
| +7 | PE to L/S Equities | 8 | 9h |
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.
Aperiam ut nihil velit. Facilis commodi quisquam enim maiores vitae porro quibusdam. Quos repellat accusamus qui dolores omnis nesciunt exercitationem. Odit veniam velit laboriosam quo.
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...