| 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 without displaying any numbers in
excel and having to paste into excel a formula. i am looking for assistance to some how average the variable and then paste the answer 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I have a created a variable with a loop, how do I find average ofvariable most efficiently? | Excel Programming | |||
| 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 | |||
Threaded Mode
