Automating row grouping for 1200 rows

J

Jayant Kumar

Hi all,
I'm new to excel, so need some help with this.
I have a total of 1200 rows with 10 data items in each row. I need to
group these rows into sets of 2's (1 and 2; 3 and 4; 5 and 6...) and
obtain the average of each of these row combinations.
Then I need to repeat the same procedure for 3 rows at a time.
What is the best way to go about doing this?

TIA,
Jayant
 
F

Frank Kabel

Hi
you could use a helper column with a formula like
=INT((ROW()-1)/2)+1
and copy this down

After this you could for example create a pivot table or use an array
formula like
=AVERAGE(IF(B1:B1200=1),A1:A1200))
for the first group (row 1+2)
 
Top