#1
|
|||
|
|||
Consolidating data with sub-cycles
Hello everyone!
Is it possible to get a result similar to one shown on the screenshot using the in-built Excel finctions? Or shall I look into VBA macros? What I am interested to get is the following: let's say I have three rows (or columns - that doesn't matter) of data pieces. Let's say it is (1) A,B,C, then (2) x,y,z, then (3) 1,2,3. I need to iterate through each of them in what is essentially subcycles - first I get A, then add x to A, then 1 to x, then 2 to x, then 3 to x, then I add y to A, then 1 to y, and so on. Last edited by Pecoflyer; 12-27-2018 at 01:09 AM. Reason: Deleted image - see attachment post #5 |
#2
|
||||
|
||||
Please post a sample sheet so we can work on it ( pics are useless) Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
I would happily work on a sheet myself. I just need to understand what kind of tool I need to utilize.
|
#4
|
||||
|
||||
Click Go advanced - Manage attachments
This forum has a FAQ where it is explained (RT...M)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#5
|
|||
|
|||
Ok, if you absolutely need my book with 18 cells of totally generic data, then here it is.
|
#6
|
|||
|
|||
Maybe you can use the attached.
|
#7
|
|||
|
|||
Thanks for the suggestion! I need some time to digest it.
How universal is this solution? I mean that my example is obviously generic, and real data would look different, and have different lengths. |
#8
|
|||
|
|||
It's always best to give full details from the start.
|
#9
|
|||
|
|||
Sorry if my initial post wasn't clear enough. The example is generic, the real data would generally be larger.
|
#10
|
|||
|
|||
Can't you be somewhat more specific as to how your data is set up?
|
#11
|
|||
|
|||
Quite like the example, but lengths of arrays can be different and random.
|
#12
|
|||
|
|||
If you want me to help any further than already done in #6 then please give full details.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Consolidating data from Word into one Excel | bartvdg | Word VBA | 4 | 09-29-2017 03:13 PM |
Consolidating Rows with same Resource Name | OTPM | Excel Programming | 2 | 05-30-2017 08:30 AM |
Consolidating various word docs in one | Max Downham | Word | 6 | 11-23-2015 05:07 PM |
Need help consolidating data from separate sheets | tiwas | Excel | 1 | 10-07-2014 04:57 AM |
Consolidating data using Macro | mrjamez | Excel Programming | 2 | 05-22-2012 06:50 AM |