Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi
I am working with a lot of arrays, and I want to be sure that I am coding most efficiently. I have to add multiply and divide arrays, so for example I want to take Array1(100) +5*Array2(100), but it doesnt look like I can just say Array3(100)=Array1(100) +5*Array2(100) I have to code For i = 1 to 100 Array3(i)=Array1(i)+Array2(i)*5 Next i Is that how you deal with arrays, by using For loops? Thanks for your help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
3D Arrays | Excel Worksheet Functions | |||
Two arrays need highlight duplicate in one of the array | Excel Worksheet Functions | |||
Confused about arrays and ranges in functions | Excel Worksheet Functions | |||
problem adding | Excel Discussion (Misc queries) | |||
Comparing Arrays | Excel Discussion (Misc queries) |