I have a series of formulas that calculate data using the RAND function, so I get a different result every time I do a re-calc. I would like to re-calc a thousand times and capture the result in a thousand different cells, so I can look for long-term trends. Any ideas?

Or if not possible, can I get Excel to do a re-calc a thousand times and record the average result of all thousand runs.

Thanks
Phil