In the simplest case, assume that all the elements are in a single column,
column A. If this is not true, then first move the elements to a single
column.

If column B enter:
=RAND() and copy down as far as column A

Sort both columns by column B. This will "shuffle" the elements in column A

Then just get the top set of elements from column A:
A1 thru A3 to sample three
A1 thru A7 to sample 7
etc.
--
Gary''s Student - gsnu200743


"mecivil" wrote:

I have to develop a user-defined function that can
be used to do random sampling of one or more elements from a sampling
frame listed in a range in Excel
When two or more elements are
sampled, the sampling needs to be done without replacement.

How can i achieve this?