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)
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)