View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
davedownunder davedownunder is offline
external usenet poster
 
Posts: 3
Default 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)