Excel formula for storing random numbers!

December 14, 2009 at 02:14:16
Specs: Windows XP
How can I store every number generated from a random number function each time in a column?

See More: Excel formula for storing random numbers!

Report •

December 14, 2009 at 06:30:40

Select the cells with the random numbers in, then:
Select the first destination cell and
Paste Special - Values

If you were doing a lot of this you could make a Macro.

Ordinary Excel formulas will retain their links to the cells containing random and will update every time anything changes and new random numbers are generated - as you probably found out.

The only answer I know, apart from the manual option given above, is to use a macro to do the equivalent of a PasteSpecial - Values.

A macro can be built-in to the worksheet, so that it runs every time cells change, but a lot depends on exactly what you are trying to do. If you want to go down this route please provide details - source cells - destination cells (and are they on the same or a different sheet). Are the cells with random numbers always the same .... and any more information to help come up with a workable solution.


Report •

December 14, 2009 at 12:31:14

You could use a macro to actually generate the random number and place the value in the cell.

See this thread as an example

Report •

January 1, 2010 at 20:54:47
Thanks you for the post.

Hi, I am a new member of forum. Would a newcomer be warmly welcome here? Good day you guys!!!

Report •

Related Solutions

Ask Question