How to automate a repetitive calculation on 3 sequential cells

Hi,

I don't know if the answer is as simple as replacing

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

abousetta

Thank you for your response!

I may not have explained this correctly -- let me try to clarify.

The way the macro is currently coded, it asks "How many trials should be summed into each session?" and we have usually put in 3. The reason being is that we always have 3 trials per session. Then we have in the past wanted to sum up the values from each trial into 1 large session value so if we had 30 trials, we'd have those 30 trials summed up into 10 sessions ( each sessiong with a group of 3 trials each).

Now what I'm trying to do is instead of having the macro simply add trial1+trial2+trial3 on each group of 3 cells that it encounters is instead to ditch the 2nd cell in each group and output the answer to the equation of (cell1 - cell3) * (cell1).

If this doesn't make sense please do ask -- and THANK YOU for looking at this!

Hi...

I'm trying to isolate the part of the code that needs modification? Is this it?

Please Login or Register  to view this content.

Also if you could post a dummy workbook then it would be helpful to visualize what you are doing exactly.

abousetta

Yes I believe that is the code that needs editing.

I have attached a sample workbook. The sheet Data Targeted shows the trials by each subject (where each subject has 3 trials in a row, before the next subject has a trial). In this worksheet, you will see that 108 subjects have 14 sessions of 3 trials each (a total of 42 trials per subject). In the worksheet Data By Session, those 42 trials per subject are summed into 14 blocks of 3 trials each using this macro.

Rather than sum those 42 trials into 14 blocks of 3 trials, I want to take those 42 trials per subject and calculate 14 values from each group of 3 trials using the equation of (Trial1 - Trial3) * (Trial1).

Thank you!

Thanks for posting the wokbook. I will try and have a look at it tomorrow and see if I can help.

If anyone can help before then, please feel free to jump in.

Good luck Excel4Lab.

abousetta

Thank you!

Bump! Anyone able to help? Thank you!