Filtering Companies With Fewer Than 5 Prospects in Excel

·

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

· Sorted by Oldest

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".
alexandre s.
·
·
Yep thanks !
Channeled
APP
·
·
Channeled
APP
·
·
Thank you so much for sharing your feedback alexandre s.!

Loading comments

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".
alexandre s.
·
·
Yep thanks !
Channeled
APP
·
·
Channeled
APP
·
·
Thank you so much for sharing your feedback alexandre s.!