Formula for Counting Contacts in People Search by Company Level
Anyone here know what's the formula for counting the number of people found from People Search based on the Company List? I can't seem to create one even using the AI function. If you have any idea how to dynamically change the limit of the people search, I'd highly appreciate it. I'm planning to find people based on management level: Top, Middle, and Lower Level in separate sheets. Limit 1 people per company. Expected Output: 1x Contact (Top), 1x Contact (Middle), 1x Contact (Lower Level) = 3 Total Contacts If no contact found: 0x Contact (Top), 2x Contact (Middle), 1x Contract (Lower Level) = 3 Total Contacts