Simple - F9, then K9, then, P9, then U9, etc...

[Steve]

....results in consecutive cells.

in row 9 I have values in specific cells ( every 5th cell).
I need those values in consecutive cells in row 25.
If
F9=230, K9 = 783, P9= 165, U9=875
I want the above as follows below:
D25 =230, E25=783, F25=165,G25=875, etc.

thanks,

Steve

 

[Jacob Skaria]

In D25 try the below formula and copy across...
=INDEX(9:9,COLUMN(A1)*5+1)

If this post helps click Yes

 

[Eduardo]

Hi,
highlight everything in row 9, hit CTRL G, special, constants, leave only
numbers checked, OK, CTRL C, go to row 25 and press CTRL V

if this helps please click yes thanks

 

[Otto Moehrbach]

Steve
Select all the cells in row 9 that you want to copy. Do this by first
clicking on F9. Then hold your Ctrl key down and select each of the rest of
the cells, K9, P9, U9. Now do Edit - Copy. Click on D25. Now do Edit -
Paste. Done. HTH Otto

 

[T. Valko]

Try this entered in D25.

=INDEX($F9:$AZ9,COLUMNS($D2525)*5-4)

Adjust for the correct end of range: $F9:$AZ9

 

[Lars-Åke Aspelin]

...results in consecutive cells.

in row 9 I have values in specific cells ( every 5th cell).
I need those values in consecutive cells in row 25.
If
F9=230, K9 = 783, P9= 165, U9=875
I want the above as follows below:
D25 =230, E25=783, F25=165,G25=875, etc.

thanks,

Steve

If you want a formula solution, try this in cell D25:

=OFFSET($F9,,5*(COLUMN()-COLUMN($D1)))

copy this across to the right as far as needed

Hope this helps / Lars-Åke

 

[Shane Devenshire]

Hi,

And yet another solution

=OFFSET($F8,,COLUMN(A1)*5-5)

 

[Lars-Åke Aspelin]

Hi,

And yet another solution

=OFFSET($F8,,COLUMN(A1)*5-5)

Shouldn't than be

=OFFSET($F9,,COLUMN(A1)*5-5)

which could be further reduced to

=OFFSET($A9,,COLUMN(A1)*5)

/ Lars-Åke

 

[Steve]

Perfect,
Thanks,

So many ways to achieve the same results, because with Lars' & Shane's
solutions also worked great.

Thanks again,

Steve

 

[Steve]

Perfect,
Thanks,

So many ways to achieve the same results, because Jacob's & Shane's
solutions also worked great.

Thanks again,

Steve

 

[Steve]

Perfect,
Thanks,

So many ways to achieve the same results, because Jacob's' & Lars'
solutions also worked great.

Thanks again,

Steve

 

[Steve]

This worked however I have other #'s in that row that I don't need, so I used
the other solutions.

Thanks,
Steve

 

[Steve]

I have to update this weekly, so I wanted to automate it more, rtaher that
re-selecting the #'s aver week, and also may eventually end up with too many.

Thanks,

Steve

 

[Steve]

This produced the same # when dragging across, but the other solutions worked
great.

Thanks
Steve

 

[T. Valko]

This produced the same # when dragging across

Hmmm...

Well, I can assure you that formula does exactly what you asked for and is
both robust and efficient.

 

[Lars-Åke Aspelin]

You must have mistyped the formula.
Check that you have written COLUMNS (not COLUMN)
Check that you have written $D2525 (not D2525 or $D25:$D25)

Hope this helps / Lars-Åke

 

[Steve]

You're right. Sorry, I must have did something wrong earlier, because it
works great now.

Thanks again

 

[Steve]

Yes, I did have columns, but I must have had something else wrong, because it
works great now.

Thanks for your patiencew.

Steve

 

[T. Valko]

Good deal! Thanks for the feedback!