Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I have a created a variable with a loop, how do I find average ofvariable most efficiently?
I want to take the average of score with displaying any numbers in
excel Sub rndgenandaver() Dim score, t, lastt t = 1 lastt = 10 ReDim score(lastt) t = 1 For t = 1 To lastt If t 0 Then score(t) = Rnd() Next t End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find monthly average but have average automatically configured | Excel Discussion (Misc queries) | |||
two variable dates created from a single date | New Users to Excel | |||
For Each ... Next loop - need to reference the loop variable | Excel Programming | |||
inadvertently created loop | Excel Programming | |||
Cells.Find error Object variable or With block variable not set | Excel Programming |