You bring up a very valid point Myrna.
But, let's have the tail wag the dog, and do an exercise, that by *no* means
is easier or better then the sort technique.
It just keeps the brain working in order to delay the onset of Alzheimer's
in guys of my age.
Suppose the Rand() function is placed in a separate WB, whose only job is to
store the random numbers.
So, when this WB is closed, since Index and Rand are not volatile, the
existing results are static, with no error messages.
Then, all you have to do is open, and then immediately close this random WB
in order to obtain a new set of returns.
Admittedly, sorting a couple of columns may be a lot simpler !
--
Regards,
RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------
Nice, one!
But it may have a down-side, namely the automatic recalculation.
When calculation is set to Automatic, you can't enter any data on this sheet
without getting a new list. And that seems to be true even if there are no
formulas in any cells. You don't have a copy of the original list unless you
copy it somewhere else and Paste special/Values.
I wonder if that's always wanted. If you use the more common technique,
requiring sorting, the user controls when a new list is produced.