Put in B column number from 1 to 100, and then use following formula in A column:
=INDIRECT(ADDRESS(1,B5,3))
Sorry for being not that detailed.
Let's say you will have in B column numbers from 1 to 100. Then you can put to the A column following formula which will take values from horizontal cells.
A5 formula will be =INDIRECT(ADDRESS(1,B5,3))
A6 formula will be =INDIRECT(ADDRESS(1,B6,3))
A7 formula will be =INDIRECT(ADDRESS(1,B7,3))
The result will be that formula will be vertically but will take values from horizontally cells.
×
73 views
Usually answered in minutes!
what i want is to put a formula verticaly but it will take from horizontal values.
i have this value
B1, B2, B3, B4
I want the formula starting from A1 to take the values from B1. Then A2 from B2........................
×