Simplifying Dedupe Process for 10k Prospect List by Job Title

Question to the clay pros Say I have a list of 10k prospects, from 3k unique companies Some companies have 5 employees, other 10, some just 1 How do you dedupe in order to keep up to x number of people per company, based on job title priorities? (my process involves breaking this down to multiple worksheets and lookup associations every time, but it's too time consuming. Wondering if anyone cracked this with something simpler)