ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   I have a created a variable with a loop, how do I find average ofvariable most efficiently? (https://www.excelbanter.com/excel-programming/413866-i-have-created-variable-loop-how-do-i-find-average-ofvariable-most-efficiently.html)

[email protected]

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


All times are GMT +1. The time now is 08:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com