ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I group multiple data entries in sub-groups (https://www.excelbanter.com/excel-worksheet-functions/37351-how-do-i-group-multiple-data-entries-sub-groups.html)

wendyrose1034

How do I group multiple data entries in sub-groups
 
I have almost 7000 data points that I need to group in sub-groups of 13
before analysing the data to measure variance. Is there a formula or macro
that I can write, or do I have to group them manually? The data points have
to be grouped in 13 in the order they appear.

bj

When you say group,
do you mean you want
to average them?
to do initial statistics on them etc.
do you wish to change from a 1x4000 to a 13x310 file

to change from a 1x4000 to a 13xYYY file
if your data is in column A and starts in row1

in C1 enter
=indirect("A"&((row()-1)*13-(column()-2)))
and copy to all cells between C1 and O310
(Note the exact lowest row depends on how many data points you actually have)
You will now have the data sorted into rows with 13 data points each

There are other things you can do depending on what you want to accomplish.


"wendyrose1034" wrote:

I have almost 7000 data points that I need to group in sub-groups of 13
before analysing the data to measure variance. Is there a formula or macro
that I can write, or do I have to group them manually? The data points have
to be grouped in 13 in the order they appear.



All times are GMT +1. The time now is 09:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com