Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Help with MS excel and random numbers recording?
In MS Excel, I have a random number generator formula setup, and every time I hit F9 to calculate it changes. Is there a way I can have my worksheet automatically record each number in a table each time it recalculates?
3 Answers
- Anonymous1 decade agoFavorite Answer
Yes, it is a macro, and should be something like this
Sub SaveRND()
sheet1.range( "C1").offset( sheet1.range( "D1").value ).value = sheet1.range( "A3").value
end sub
This will work if you have
C1 the start of the list of random numbers
D1 has the formula =counta(C:C)
A3 has the formula that generates the random number
good luck with that,
If you need more info, mail me
Read my profile, i am the XLMan
- ?Lv 45 years ago
quite in case you attempt to circumvent repetition, then the technology can't be random. Is it? wherein case the RANDBETWEEN function can't be the main suitable selection... Off the astonishing of my head, i could say it can be a techniques much less complicated to %. the numbers at random from a type, Set, or Array, which gets decreased in length each and every time by removing the selection picked. HTH ( slightly.. ).
- 1 decade ago
the way is whit a macro, if you want send me the file and i can do for you. write to aguilarsu@yahoo.com
