Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-25-2018, 12:21 PM
Scaffold Scaffold is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Oct 2009
Location: Moscow, Russia
Posts: 26
Scaffold is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 12-26-2018, 12:49 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,381
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Please post a sample sheet so we can work on it ( pics are useless) Thx
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #3  
Old 12-26-2018, 12:54 AM
Scaffold Scaffold is offline Windows 10 Office 2016
Novice
 
Join Date: Oct 2009
Location: Moscow, Russia
Posts: 26
Scaffold is on a distinguished road
Default

I would happily work on a sheet myself. I just need to understand what kind of tool I need to utilize.
Reply With Quote
  #4  
Old 12-26-2018, 01:28 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,381
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Click Go advanced - Manage attachments
This forum has a FAQ where it is explained (RT...M)
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #5  
Old 12-26-2018, 01:43 AM
Scaffold Scaffold is offline Windows 10 Office 2016
Novice
 
Join Date: Oct 2009
Location: Moscow, Russia
Posts: 26
Scaffold is on a distinguished road
Default

Ok, if you absolutely need my book with 18 cells of totally generic data, then here it is.
Attached Files
File Type: xlsx book.xlsx (8.1 KB, 1 views)
Reply With Quote
  #6  
Old 12-26-2018, 02:06 AM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,019
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

Maybe you can use the attached.
Attached Files
File Type: xlsx Repeat_ABC.xlsx (45.0 KB, 2 views)
Reply With Quote
  #7  
Old 12-26-2018, 02:14 AM
Scaffold Scaffold is offline Windows 10 Office 2016
Novice
 
Join Date: Oct 2009
Location: Moscow, Russia
Posts: 26
Scaffold is on a distinguished road
Default

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.
Reply With Quote
  #8  
Old 12-26-2018, 02:27 AM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,019
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

It's always best to give full details from the start.
Reply With Quote
  #9  
Old 12-26-2018, 03:02 AM
Scaffold Scaffold is offline Windows 10 Office 2016
Novice
 
Join Date: Oct 2009
Location: Moscow, Russia
Posts: 26
Scaffold is on a distinguished road
Default

Sorry if my initial post wasn't clear enough. The example is generic, the real data would generally be larger.
Reply With Quote
  #10  
Old 12-26-2018, 08:18 AM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,019
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

Can't you be somewhat more specific as to how your data is set up?
Reply With Quote
  #11  
Old 12-26-2018, 11:47 AM
Scaffold Scaffold is offline Windows 10 Office 2016
Novice
 
Join Date: Oct 2009
Location: Moscow, Russia
Posts: 26
Scaffold is on a distinguished road
Default

Quite like the example, but lengths of arrays can be different and random.
Reply With Quote
  #12  
Old 12-27-2018, 02:14 AM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,019
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

If you want me to help any further than already done in #6 then please give full details.
Reply With Quote
Reply

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 07:42 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft