Randomly Choose Cells from Colum/Row

1. Randomly Choose Cells from Colum/Row

hello. i'm not sure if this is possible, but i'm trying to randomly select
multiple cells from a colum to be evaluated. for example, say i have a clumn
of 10 cells. i'd like this function in another cell to select 3 cells from
the 10 at random. is this possible? thanks

2. RE: Randomly Choose Cells from Colum/Row

In a column next to the column containing the ten data items enter:

=RAND() and copy down. Touch F9 and then sort by the newly entered column.
This will "randomize" your data. Just take the top three cells.

Whenever you want a new sample, repeat the process
--
Gary''s Student

"J" wrote:

> hello. i'm not sure if this is possible, but i'm trying to randomly select
> multiple cells from a colum to be evaluated. for example, say i have a clumn
> of 10 cells. i'd like this function in another cell to select 3 cells from
> the 10 at random. is this possible? thanks

3. Re: Randomly Choose Cells from Colum/Row

Another variation to try ..

Assume the 10 source items are listed in A1:A10

Put in B1: =RAND()
Copy B1 down to B10

Put in C1: =INDEX(A:A,RANK(B1,\$B\$1:\$B\$10))
Copy C1 down to C3

C1:C3 will return a random, non-repeating selection
of 3 items from within A1:A10

And if you want to random select more than 3 items,
just copy C1 down further to C4, C5, .. or all the way to C10
to get the random full scramble of what's in A1:A10

To regenerate a fresh random selection, just press F9
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"J" <J@discussions.microsoft.com> wrote in message
news:C02D96E4-9408-466E-B267-C54316D9FBD7@microsoft.com...
> hello. i'm not sure if this is possible, but i'm trying to randomly select
> multiple cells from a colum to be evaluated. for example, say i have a

clumn
> of 10 cells. i'd like this function in another cell to select 3 cells from
> the 10 at random. is this possible? thanks

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1