place array at calculated position

D

davedownunder

Excel 2007

i have an array of data c10:AL10 which contains data.

I have another row which has a couple of logical operations ANDed together.
i.e.
c50=1, d50=2, e50=3, f50=4, g50=5

I want to place the content of c10 in a third row, eg 60, at the same column
as the 2nd row =3

so H60=c10, I60=d10, J60=e10 and so on for 36 values

How the heck do i do it - i have complete freedom in my solution constrained
only by competence (mine)
 
D

davedownunder

gah - ignore the line that talks about logical ANDs - it is simply a row of
data (i changed my mind about the example and didn't edit the posting - sorry
:-(
 
J

Jacob Skaria

In H60 enter the formula and copy across...

=INDEX($C$10:$AL$10,COLUMN(A1))

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top