Hi to all New noob member here asking for help .HEEEELP
i want to put vertical values to a selected space with horizontal orientation
see the excel file
Hi to all New noob member here asking for help .HEEEELP
i want to put vertical values to a selected space with horizontal orientation
see the excel file
Last edited by kanelonis; 02-20-2013 at 05:25 PM.
Do you want to go down to row 34 and then start the next column or Across to Col AC and then start the next row?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Assuming based on your wording, the second, across, then down
=IFERROR(INDEX($C$38:$C$259,( MOD(COLUMN(A1)-1,24)+1)+24*(ROW(A1)-1)),"") in F4 copied across and down.
Does that work for you?
Hi ChemistB...thank you for your reply
i want my values to go from F4 to AC4 and then continue from F5 to AC5 and so on .
Could this be possible?
ChemistB
ChemistB is online now
Forum Guru
Join Date
08-05-2004
Location
NJ
MS-Off Ver
MS 2007, 2010
Posts
6,869
Re: Fill in vertical values to selected area with horisontal orientation
Assuming based on your wording, the second, across, then down
=IFERROR(INDEX($C$38:$C$259,( MOD(COLUMN(A1)-1,24)+1)+24*(ROW(A1)-1)),"") in F4 copied across and down.
Does that work for you?
my noobish brain did not get that )))
you mean in F4 i should type this formula?
Yes, you can then copy and paste that to all other cells (or drag to copy paste)
i tried it but it finds an error in =IFERROR(INDEX($C$38:$C$259,( MOD(COLUMN(A1)-1,24)+1)+24*(ROW(A1)-1)),"")
and it doesnt work...unless if its a noobish mistake of mine
and if i have more values i just change the 259 correct?
Here it is in the worksheet you provided. Not sure what you are doing wrong.
Yeahhhh it worked.
I am really thankful for your help ChemistB i have been trying to find a path in this labyrinth all day without result .
unlimited stars from me for your special help
if i have more issues with excel could i ask you again?
with Best Regards Kanelonis
Glad I could help. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks