How do I extract every 12th number in a column?
Posted by John Davidson on January 18, 2001 2:11 PM
My problem continues.
I need to create a formula that will extract specific data from a column and place this data in specific cells in the same row. Specifically, I need to pull the data from every 12th cell in column AA (AA12, AA24, AA36, etc..)and place this data in consecutive cells in row 25 (A25, B25, C25, etc..) To make matters worse, a logical test needs to be run to determine if it is appropriate to begin this data movement. What I mean is that depending upon the result of this logical test, the data in the AA column may start in A25 or B25 and so on. If the data in cell AA12 is to go in A25, then the data in AA24 needs to go in B25 and so on. If the test determines that the data in cell AA12 needs to start in B25, then AA24 needs to go in C25 and so on.
With the help of some on-line folks, it was recommended that I use OFFSET commands with ROW and/or COLUMN commands included. I can not get this to work.
Any help would be greatly appreciated.
Posted by Scott R on January 19, 2001 9:28 AM
Put the following formula in A25 and copy right for as many columns as necessary to pick up your AA data:
=OFFSET($AA$12,(COLUMNS($A$25:A$25)-$A$1)*12-12,0)
where your logical test is entered in A1. Logical = 0 starts data in Col. A; logical = 1 starts data in Col. B; etc. I'll leave it to you to hide #REF! cells.
