| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
2 dimensional loop, averageif formula
Hope the following will solve the problem
For i = lastrw + 2 To lastrw + 4 For ii = lastcol - 37 To lastcol Cells(i, ii).Formula = "=averageif(a1:a" & lastrw & ",b" & i & ",c1:c" & lastcol & ")" Next ii Next i |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AVERAGEIF FORMULA EXCEL 2007 | Excel Discussion (Misc queries) | |||
| Help with Averageif Formula (don't think I should use Averageif) | Excel Discussion (Misc queries) | |||
| Export 1-dimensional array values to a two-dimensional table? | Excel Programming | |||
| Changing a two-dimensional, one row array to one-dimensional | Excel Programming | |||
| How to generate formula from two dimensional array of data | Excel Worksheet Functions | |||
Threaded Mode
