| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Position of first number in array greater than a given number | Excel Worksheet Functions | |||
| Can I use a 'calculated' array in a function? | Excel Worksheet Functions | |||
| how to sort a range which is calculated by array formula | Excel Discussion (Misc queries) | |||
| Array to find relative position - is there a better way? | Excel Worksheet Functions | |||
| Can I make array position A(12) into a variable A(12*n) ? | Excel Worksheet Functions | |||
Hybrid Mode
