Subsampling a Column of Data

R

rwmill9716

Active Member
Joined
May 20, 2006
Messages
493
Office Version
  1. 2013
Platform
  1. Windows
I have 1,000 data in Col D (rows 5 through 1004);

I want to copy the first 12 to Col L (rows 5 through 16) where I will do several
calculations to end up with a single average in cell M1;

I now want to copy a second set of 12 from col D which are in D6 through D17 again
into rows 5 through 16 of Col L where again my calculations will end up with a single
average in cell M1;

And so on through the entire 1000 data in Col D, always plucking 12 into col L (rows
5 through 16) where I'll do calculations that end up with an average in M1.

I would like to run through the 1,000 (perhaps by hitting F9 for each set of new calculations) and save the 1,000 data placed in M1.

Thanks,

Ric
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Sort by date Sort by votes
I am rephrasing the problem.

copy D5:D16 in L5:L16
find average(orsome other calcualtion) of L5:L16 and copy this to M1
ok
next copy D6:D17 to L5:L16
the old L5:L16 will be overwritten
find average of L5:L16 and copy this to M1
what is the idea? the old M1 is overwritten

next copy D7:D18 to L5:L16.
again the old L5:L16 is overwritten
find average of new L5"L16 and copy to M1
again old M1 is overwritten.

go on till the last row -11

what is the idea. why should you copy to
column L. why not straightaway find average of
D5:D16,D6:D17.D7:D18.

do you want to copy these averages on M1 itself over
writing previous M1 or copy in M1, M2 M3 etc.


please clarify these points.

<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question
Finding a way to swap column data based on calculated total limit
Replies
0
Views
290
bradgirman
B
D
  • Solved
Timesheet Calculation
Replies
7
Views
782
jorismoerings
J
montecarlo2012
  • Solved
vba=Loop through each row in the data range.(B2:F10000)
Replies
9
Views
2K
montecarlo2012
montecarlo2012
H
  • Solved
Macro to copy data based on specific criteria
Replies
6
Views
362
howard
H
T
  • Solved
Using VBA to Copy and Paste a 2D Array in Excel
Replies
3
Views
965
Fluff
Fluff

Forum statistics

Threads
1,214,943
Messages
6,122,370
Members
449,080
Latest member
Armadillos

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top