Community
Showing results for 
Search instead for 
Do you mean 
Reply

Looking up companies with <N number of contacts

Accepted Solution Solved
New Member
Posts: 3
Country: Canada
Accepted Solution

Looking up companies with <N number of contacts

Can I Look up companies in ACT! database that have less than certain amount of contacts? For example, I want to look up companies that have two or less contacts. Thanks.


Accepted Solutions
Solution
Accepted by topic author Research_MultiCam
‎02-22-2016 06:26 AM
Administrator
Posts: 4,024
Country: United_Kingdom

Re: Looking up companies with <N number of contacts

Hi There,
It's not possible to do this as a direct lookup in Act, however you could export a list of your contacts, with the company column showing, to excel, and use a formula or pivot table to see number of contacts in a with the same company name, and filter on the results.

View solution in original post


All Replies
Solution
Accepted by topic author Research_MultiCam
‎02-22-2016 06:26 AM
Administrator
Posts: 4,024
Country: United_Kingdom

Re: Looking up companies with <N number of contacts

Hi There,
It's not possible to do this as a direct lookup in Act, however you could export a list of your contacts, with the company column showing, to excel, and use a formula or pivot table to see number of contacts in a with the same company name, and filter on the results.