RebeccaMulder1975
New Member
- Joined
- Apr 16, 2018
- Messages
- 1
...but after days of dedicated Googling that have not yielded results, I need help.
In a nutshell, I use huge datasets to run a dashboard and to make it work I need to relabel each line of data to tell me what Division it applies to, and what Function. Bearing in mind these are workforce reports, they're huge (over 3000 rows with multiple columns for each).
Up until now, I have been happily using COUNTIF to tell me what the Division of an employee should be, based on their physical location. Example below - I use their GEO code to update the report with their associated division - I add a new column and embed this formula:
=IF($Z:$Z="AUT","Central Eastern Europe",<o
></o>
IF($Z:$Z="AZE","HGEM",<o></o>
IF($Z:$Z="BEL","Western Europe",<o></o>
IF($Z:$Z="BGR","Central Eastern Europe",<o></o>
IF($Z:$Z="BIH","Central Eastern Europe",<o></o>
IF($Z:$Z="BLR","HGEM"))))))))))))))))))))))
This works fine, but now I need to apply the same logic to their Layer 1 Manager, which means a hell of a lot more variables to look at - got over 500 names I need to convert to the right job function, based on a list I have. My Countif won't work, probably because it's way too massive.
How do I do this? I would attach examples, but it's all super confidential and I want to stay employed. Thinking maybe I could use a macro to sort it out, but bloody clueless on those too.
Is there a more efficient way to run a Countif to cover such a huge dataset, and that will input the right function data in the new column I create, based on the Layer 1 Manager? Otherwise, it will have to be manual and that will take hours.
Help meeee!
Thanks
Rebecca
In a nutshell, I use huge datasets to run a dashboard and to make it work I need to relabel each line of data to tell me what Division it applies to, and what Function. Bearing in mind these are workforce reports, they're huge (over 3000 rows with multiple columns for each).
Up until now, I have been happily using COUNTIF to tell me what the Division of an employee should be, based on their physical location. Example below - I use their GEO code to update the report with their associated division - I add a new column and embed this formula:
=IF($Z:$Z="AUT","Central Eastern Europe",<o
></o>IF($Z:$Z="AZE","HGEM",<o
></o>IF($Z:$Z="BEL","Western Europe",<o
></o>IF($Z:$Z="BGR","Central Eastern Europe",<o
></o>IF($Z:$Z="BIH","Central Eastern Europe",<o
></o>IF($Z:$Z="BLR","HGEM"))))))))))))))))))))))
This works fine, but now I need to apply the same logic to their Layer 1 Manager, which means a hell of a lot more variables to look at - got over 500 names I need to convert to the right job function, based on a list I have. My Countif won't work, probably because it's way too massive.
How do I do this? I would attach examples, but it's all super confidential and I want to stay employed. Thinking maybe I could use a macro to sort it out, but bloody clueless on those too.
Is there a more efficient way to run a Countif to cover such a huge dataset, and that will input the right function data in the new column I create, based on the Layer 1 Manager? Otherwise, it will have to be manual and that will take hours.
Help meeee!
Thanks
Rebecca
