Edit:
I uploaded now my Excel sheet so that you won't have to trouble yourselves.
- - - - - - -
Hi there,
I'm helping to run a study and my worksheet contains about 130,000 rows...it's huge (at least for me)!
It's presented in increments of 8 milliseconds and I would like to sum up every 125 rows so that it presents a second, but I would like to do it for every subject (every subject is presented as his or her last 4 ID digits, so there is subject 6492 and there is subject 3729 for exmaple and so on). So as I said, I want to sum up every 125 rows of every subject, so that if a subject have, for example, 126 rows, excel won't include the last row for this subject but for the next one (to sum the rows up until the subject number changes).
I did it for the first 125 rows but I don't know how to do it over and over taking into account that a single subject's data may not divide precisely in 125.
Then I have to extract the first second of the all of the subjects to one sheet, the second one on another sheet and so on, but I guess there it gets more complicated so even if you help me find the first step I would be thrilled.
Thanks a lot in advance!
Bookmarks