LinkND
07-02-2008, 04:01 AM
I am working on a list of values with company names and their employees. Every company name is unique, but has different unique daughter companies. So for example, I have company number 1, with sub_company 1, 2 and 3. Company number 2, with sub_company 1 and 2, etc.
Alright, every sub_company within a total company has different employees. You can count all the employees and make a list of companies with the biggest on top. This list is already created, as the list with the top companies.
What I want to do is find the total amount of employees for every sub_company by looping through the list at the left. Because every sub_company can be listed more than once, it needs to count all the employees together. I want to create this list only for the top 3 companies in the list (the list in the middle). Even though that list with top companies can be 1000 rows long, only the first three will be used.
I've attached an example workbook to this post, because you will see exactly what I want to accomplish.
Alright, every sub_company within a total company has different employees. You can count all the employees and make a list of companies with the biggest on top. This list is already created, as the list with the top companies.
What I want to do is find the total amount of employees for every sub_company by looping through the list at the left. Because every sub_company can be listed more than once, it needs to count all the employees together. I want to create this list only for the top 3 companies in the list (the list in the middle). Even though that list with top companies can be 1000 rows long, only the first three will be used.
I've attached an example workbook to this post, because you will see exactly what I want to accomplish.