Subpage under development, new version coming soon!
Subject: excel help
- 1
oxolotl [del] to
All
Haven't got that much experience with macros, but was wondering what i would need to do to do the following:
I have some data like this:
Time Response
99 55
100 54
101 54
249 56
250 59
251 52
I really only want the sum of each 'set of three' responses, as they are effectively the same response just split up.
The data goes on for x amount of time points, i want a macro that will start at a user defined point and then sum together the next 21 'sets of three' and put them into a new column (that is static for all worksheets), i.e i have 21 responses rather than 63! Is there any way to do this?
I have some data like this:
Time Response
99 55
100 54
101 54
249 56
250 59
251 52
I really only want the sum of each 'set of three' responses, as they are effectively the same response just split up.
The data goes on for x amount of time points, i want a macro that will start at a user defined point and then sum together the next 21 'sets of three' and put them into a new column (that is static for all worksheets), i.e i have 21 responses rather than 63! Is there any way to do this?
- 1