Copy values separated by a set number of columns

[Pablo]

I have a spreadsheet set up like this:


A B C D E F
1 2/13/2009 2/14/2009 2/15/2009
2 Plan Actual Plan Actual Plan Actual
3 W X Y Z AA AB

In a separate tab, I want to be able to group all the Daily Plan and Daily
Actual by date. Is there a way to copy the values that are separated by two
columns? In other words, copy the value for A3, then C3, and E3 for all the
planned results.

Thanks,

 

[Max]

..copy the value for A3, then C3, and E3 for all the planned results.

Assuming source data as posted in Sheet1
In another sheet,
Put this in any start cell, eg in B2:
=OFFSET(Sheet1!$A$3,,ROWS($1:1)*2-2)
Copy down to return as desired

Click YES below if it helped
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik