Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
A big ask, but if anyone can help, it would be great. I'm
getting tied up in nested for...next loops and ifs. I have a square array K(n,n) I also have a vector array Vector(n) The entries in Vector() are either 1 or 0, i.e (1,1,0,0,1,1). Here n = 6 There are a total of 4 1's in Vector in this example. I need to reduce K() by deleting the rows and columns corresponding to the location of a 1 in Vector() to obatin K_Red Continuining the above example: K_Red(2,2) The entries in K_Red() will correspond to entries in K() at the following locations. i.e. K_red(1,1)=K(3,3), K_red(1,2)=K(3,4) K_red(2,1)=K(4,3), K_red(2,2) =K(4,4) Now how can I do the same where n is a large number. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Arrays | Excel Discussion (Misc queries) | |||
help with arrays | Excel Programming | |||
Arrays | Excel Programming | |||
Arrays | Excel Programming | |||
arrays | Excel Programming |