One of my friends suggested the following:

1. Sort by the random column from top to bottom. See how many rows are in the entire column and take x% of that number.
2. Use conditonal formatting in the unsorted Random() column. Color / format the top or bottom x%
3. There is most likely a Large(Range, x% or no or rows) formula and Small would work also.
4. How about picking all random numbers that have a .1 in the tenths digit?
5. This seems like it could go on all random digit day.

Example: Put random numbers in an entire column. Conditional Format the numbers to color the bottom x%. Find two people you want on the same team and press Calculate until they are both CF colored. Use this as your "Random" sorting.

If by the above steps, sorting the column of random values will help to get a continuous range of data, then how can that be done? If it doesn't work, then, how can the filtered range be made continuous?

Any suggestion, Bob? You are the the VBAX lord here


Sarang