Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
wendyrose1034
 
Posts: n/a
Default 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.
  #2   Report Post  
bj
 
Posts: n/a
Default

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I Select Multiple entries from Valid list for a Cell WIDBIS Excel Discussion (Misc queries) 1 June 29th 05 12:53 AM
how do i import multiple data sets at one time? chris_rip Excel Discussion (Misc queries) 3 June 22nd 05 04:27 AM
Reference multiple cells in if statement PAR Excel Worksheet Functions 1 June 10th 05 06:28 AM
Combining data from multiple sheets Ron Vetter Excel Discussion (Misc queries) 1 April 29th 05 08:02 PM
Combining data (numeric format) in multiple cells into one cell (t GNAC SID Excel Discussion (Misc queries) 2 February 7th 05 04:09 PM


All times are GMT +1. The time now is 03:20 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"