Hello.

I have a table (9 columns, 500 rows) of 3-digit random numbers ranging from 001-999. Naturally, numbers are repeated - at random - throughout the table. I want Excel to generate a single-column list of unique numbers from the table according to the following parameters:

*User defines quantity of numbers to select.
*User defines the cell from which to begin number selection. (Or, Excel randomly selects a cell from which to begin number selection.)
*User defines a range of values that are acceptable for selection.
*Excel "reads" the table from left-to-right across the columns and from top-to-bottom down the rows, selecting non-repeating numbers from the table that fall with the user-defined range. If Excel finds a cell containing a number that has been previously selected or that is outside of the user-defined range, it skips to the next cell.

This can't be something too complicated to program, but clearly I don't know any appropriate code. I imagine that there might even be a pre-programmed function or macro to accomplish this. Can anyone shed some light on this for me?

Thanks.