Clay Icon
Join the Community
02 Support

How to Filter Enriched Data in Excel for Finding Specific LinkedIn Profiles that Worked as Founders

Avatar of Muhammad S.Muhammad S.
·
·

Hi, I am trying to figure out how to apply a filter in the enriched data? I have linkedin profiles in column A and I am trying to find out how many times a specific person worked as a founder. Is there a way to do this? Thanks!

6 comments

  • Avatar of Vishesh J.
    Vishesh J.
    ·
    ·

    So it will be a bit tricky. You would need to create a custom Clay formula to count it. and See how many times Founders was used. Easier Option is, that you use GPT and put The entire Experience in the input and ask it how many times this guy has been founder. A bit more expensive. But if you have a small list. This might work.

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    Hi Muhammad S.! Happy to provide some thoughts here

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    One way would be to use the 'Experience' field from the Enrich Person column to count the number of times "founder" is used in the experience descriptions. I think this is what Vishesh was getting at

  • Avatar of Clay T.
    Clay T.
    APP
    ·
    ·

    I've gone ahead and created a formula column on the far right of your table titles "founder count", let me know if this achieves what you're looking for

  • Avatar of Muhammad S.
    Muhammad S.
    ·
    ·

    Thank you!!