This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit FeedbackHandled this with a macro, but would've loved to turn it into a single macro... The awesome macro logic is from CReW macros!
Update after looking at the solution: Went way complicated... Forgot about that simple transpose trick 🙂
This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.
Hi All,
Through trial and error I finally came up to the solution that surprised me a bit :).
The pattern is that we need to apply two (similar) calculations to a few sets of data (grouped by HP Category).
After cleaning NULL values I applied multi-row formula tool 12 times and it worked fine, here is my solution:
This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.
Found my solution. This link helped me a lot!
This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.
Here is my solution:
This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.
This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.
Mine is slightly different than the solution provided. I used an extra column called avg_name to determine whether it is a 3mo or 6 mo and then did a union before my crosstab.
This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.
Here's my solution
This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.