Calculating the difference across columns for a fixed row length.
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I have an excel sheet that has columns as Jan, Feb, March up to December as shown in the image below.
I would like to calculate the difference between A & B (A-B) for January, February, up to December on row 4, then the difference between C&D (C-D) for January, February up to December on row 7. I would like to follow the same pattern up to row 730.
Can somebody please suggest a macro-free way of performing the calculations?
Thank you in advance!
Solved! Go to Solution.
- Labels:
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi
I think the Multi-Row Formula tool is useful for this. It takes time to solve because I don't have the data.
Regards
Arundhuti
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey there,
I made up an example where I'm using a multi-row formula to do the calculation if the word "Difference" is found. This means that for every line with Difference, it''ll take up the two numbers above and subtract them.
In this method, you'll need 1 multi-row formula tool for each month, but you won't be needing a macro.
Let me know if this can help you out or if you have any questions!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Jack6627
I would highly recommend checking out this macro that @patrick_digan created: https://gallery.alteryx.com/#!app/Multi-Row-Multi-Field/59639862effc2a0c04c7e653
It combines the functionality of both the Multi-Row and Multi-Field formula tools.
If you don't feel like downloading this macro, here is how you can do it with the standard tools.
Let me know if this works for you.
Cheers!
Phil
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This worked! Thank you @Maskell_Rascal. I am a beginner to Alteryx and hence wanted a macro free solution. I will take a look at the macro as I get a deeper understanding of Alteryx. 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
