I have a list of twenty real number in A1 to A20.
How can I randomly select a number from the list, but not the one with
value = 0
If the selected number is zero, it will automatically select another
random number from the list.
The list is dynamic, so I don't know exactly when and where the ones
with zero value show up.
Thank you.

Katherine.


--
kathyxyz
------------------------------------------------------------------------
kathyxyz's Profile: http://www.excelforum.com/member.php...o&userid=25624
View this thread: http://www.excelforum.com/showthread...hreadid=390385