Clay Icon
Join the Community
03 Tutorials & Inspiration

Filtering Companies With Fewer Than 5 Prospects in Excel

Avatar of alexandre s.alexandre s.
·
·

Hi guys, I have a list of prospects with a URL domain for each .I want to filter on companies with less than 5 prospects in the table. I tried formulas but didn't succeed. Any advice ?

4 comments

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    To filter companies with less than 5 prospects in your table using URL domains, you can use the Lookup Multiple Rows integration. Here's how: 1. Use the Lookup Multiple Rows integration to count prospects for each company. 2. Scan the domain column to count matching values. 3. Create a new column with the count results. 4. Use a conditional formula to filter companies with less than 5 prospects. For example, you could use a formula like: IF(COUNT_OF_PROSPECTS < 5, "Include", "Exclude"). If you need more detailed guidance on setting this up, please request human assistance by clicking on "Talk to a person".

  • Avatar of alexandre s.
    alexandre s.
    ·
    ·

    Yep thanks !

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·
  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Thank you so much for sharing your feedback ​alexandre s.​!