Last week's solution can be found here!
This week's challenge is around assigning the right income tax rate to each salary. Your goal is to count the number of people associated with each tax rate.
In our starting workflow, you'll find three datasets:
1) A grid of 100 employees from 26 companies. Before everyone gets worried, yes, I randomly generate this salary data and it is not representative of the population! Do note that each salary has a 'I' or 'J" representing whether this salary will be filed jointly or individually
2) A list of the company names
3) A tax table with the income rates. Notice that there is not a range in the tax table. You must infer the range based on when the next tax rate starts.
1) Solve this problem as is.
1) Do not use: Join, Crosstab, Transpose, Multi-field Formula, or Multi-Row Formula
Why take the easy path when you can do it the hard way? Which, coincidentally, is generally how I approach my taxes.
My solution! Complete with super cute piggy bank macro icon!
Super fun challenge, @JoeM!! I really enjoyed this Monday morning brain teaser 🙂
Two macro solution. It's fun trying to find a harder solution (which is actually better than what I was trying to do the easy way), to make you think outside the box every now and then.
@WilliamR, I put all the restrictions to see if I could get people to discover a tool that would make their life easier. It was not Arrange that I was aiming to have people discover, but when I was thinking about disallowing it for the 'hard' way, I decided it was also a handy tool to have exposure to. I just didn't think anyone would do it (except for the one and only @Joe_Mako of course)!