Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |