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

  • Thread starter Thread starter Steve
  • Start date Start date
S

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
 
In D25 try the below formula and copy across...
=INDEX(9:9,COLUMN(A1)*5+1)

If this post helps click Yes
 
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
 
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
 
Try this entered in D25.

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

Adjust for the correct end of range: $F9:$AZ9
 
...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
Click to expand...

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
 
Hi,

And yet another solution

=OFFSET($F8,,COLUMN(A1)*5-5)
Click to expand...

Shouldn't than be

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

which could be further reduced to

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

/ Lars-Åke
 
Perfect,
Thanks,

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

Thanks again,

Steve
 
Perfect,
Thanks,

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

Thanks again,

Steve
 
Perfect,
Thanks,

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

Thanks again,

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

Thanks,
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
 
This produced the same # when dragging across, but the other solutions worked
great.

Thanks
Steve
 
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.
 
You must have mistyped the formula.
Check that you have written COLUMNS (not COLUMN)
Check that you have written $D25:D25 (not D25:D25 or $D25:$D25)

Hope this helps / Lars-Åke
 
You're right. Sorry, I must have did something wrong earlier, because it
works great now.

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

Thanks for your patiencew.

Steve
 
Back
Top