LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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)

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Position of first number in array greater than a given number Krapdad Excel Worksheet Functions 4 April 3rd 09 05:02 PM
Can I use a 'calculated' array in a function? CalculatedArray Excel Worksheet Functions 3 January 30th 09 02:53 AM
how to sort a range which is calculated by array formula leoease Excel Discussion (Misc queries) 1 December 12th 07 03:30 PM
Array to find relative position - is there a better way? John Michl Excel Worksheet Functions 3 October 8th 07 04:47 PM
Can I make array position A(12) into a variable A(12*n) ? Paul Excel Worksheet Functions 1 October 9th 06 10:37 PM


All times are GMT +1. The time now is 09:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"