I work for a marketing company. I need a formula to return a limited number of contacts per company for database. Essentially if I have a list of say 1000 contacts across various companies, some companies may have 100 contacts some may have 10 , I want to set a limit that only returns 5 per company for example.
Essentially I want to deduplicate BUT leave 5 per company (this number may vary so I need a formula thats easy to adjust) instead of 1.
The formula would need to work off the company name/company domain column.
14 freelancers están ofertando un promedio de €23 por este trabajo
Hi, I can help you on your file. I have an advanced knowledge on Excel's formulas including pivot table, charts and visual basic coding. I'm willing to discuss more about your project.