place array at calculated position
 

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)

place array at calculated position
 

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
:-(

"davedownunder" wrote:

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)

place array at calculated position
 

In H60 enter the formula and copy across...

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

If this post helps click Yes
---------------
Jacob Skaria


"davedownunder" wrote:

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
:-(

"davedownunder" wrote:

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)