One way. If your numbers are in A1:A100 then in B1 put
=IF(RAND()<=0.1,"Select this","")
Change the fraction 0.1 until you're satisfied with the selection.. Then
copy the cells B1:B100 and
paste special/values back into B1:B100 or another column because RAND() is
a volatile function
and is recalculated anytime anything else on the worksheet is calculated
RAND() generates random numbers from 0 through less than 1 - i.e.
0.99999999999999999 or so..

Tyro

"Renegade" wrote in message
...
In an Excel spreadsheet, is there a method to randomly select criteria off
the worksheet? For example, I need to randomly select (1% or 40 items)
from
the list to conduct an analysis. If this can be accomplished, would you
be
willing to share your process for accomplishing same. Thanks in advance.