function to change cell position and allows dragging

T

Tarheel9328

I want to enter a formula that will reference a particular cell, and then
allow me to drag the formula down so it references every third cell.

So, if my data is:
A
1 XOM
2 WFT
3 SLB
4 HD
5 LOW
6 BAC
7 GE
8 MSFT

(Imagine the list is much longer) and I would like to write a formula that
allows me to create a smaller list composed of every third entry. So the
first entry would be XOM, then when I dragged the formula down, the next cell
would be HD, then GE, and so forth. Any ideas?
 
K

Ken Johnson

Tarheel9328 said:
I want to enter a formula that will reference a particular cell, and then
allow me to drag the formula down so it references every third cell.

So, if my data is:
A
1 XOM
2 WFT
3 SLB
4 HD
5 LOW
6 BAC
7 GE
8 MSFT

(Imagine the list is much longer) and I would like to write a formula that
allows me to create a smaller list composed of every third entry. So the
first entry would be XOM, then when I dragged the formula down, the next cell
would be HD, then GE, and so forth. Any ideas?
Click to expand...

B1 formula... =A1
B2 formula... =INDIRECT("A" & ROW()*3 - 2)

Filldown formula in B2

Ken Johnson
 
K

Ken Johnson

Ken said:
B1 formula... =A1
B2 formula... =INDIRECT("A" & ROW()*3 - 2)

Filldown formula in B2

Ken Johnson
Click to expand...

Actually B1 formula... =INDIRECT("A" & ROW()*3 - 2) then filldown B1

Ken Johnson
 
Top