Hi
I have 1 column and 24 rows
i want to know if there is a way to generate these values in its sequence to form 360 times for each iteration randomly increasing or decreasing it by 10%
ive attached a sample
example
1
2
3
4
5
6
7
24
after iteration
1.1
2.2
3.3
4.4
5.5
6.6
7.7
26.4
i want the same sequence of 24 values + or - 10% to continue until i reach row 8640
I have no idea how this question relates to the file you attached. See Sheet1 for a formula solution. This uses a random number generator so the numbers change every time there is a recalculation. If you want to freeze the values then do a Copy, Paste Values. This requires a "helper" column with the number (0.1 or -0.1) to multiply each group of 24 numbers.
If you don't want to bother with the Copy/Paste then you need a macro solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks