Re: Formula to choose X number of unique random cells from array?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi

Assume the name are in column A, and the Rand function in B ( you have to
fill down until you reach the last row of the namwe column.
Sort column A & B on B.
Then take the first 50 entries in column A.
--
Regards

Jean-Yves Tfelt
Europe


"Techhead" wrote:

On Apr 17, 9:34 am, Jean-Yves <JeanY...@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
Hi,

Add a formual in next column with function "RAND( )"
Sort on that column and take the first 50.
The rand function will also be recalculted each time a sortin is done.

--
Regards

Jean-Yves Tfelt
Europe



"Techhead" wrote:
How would I create a formula to choose X number of unique cells from
an array? For example,

A1 = Bob
A2 = Mary
A3 = Bill
A4 = Tom
A5 = Dick

I need to choose at random, 3 of these names and they have to be
unique. On a larger scale, I have a database of 1500 names and I need
to select 50 unique names (cells) at random.

Thanks,
Brian- Hide quoted text -

- Show quoted text -

Putting RAND() on the next column over only gives me a decimal
numerical value. How would I apply the RAND() function on Column A?

.

Relevant Pages

  • Re: Random numbers in 5mx Sheet
    ... >>> This should seed the Rand function. ... Of course it will always be pseudo-random. ... but it underlines the problem with RAND. ... In fact, cell B8 is pointless, because it will always use the same ...
    (comp.sys.psion.apps)
  • How to get repeatable Excel RAND sequence?
    ... subsequent calls to RAND result in a repeatable sequence? ... I want to use Excel RAND per se; ... repeatable sequence by default, and it required setting the RANDOMIZE ... does anyone know exactly how the Excel 2003 RAND function is ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Random number help
    ... help rand ... Nishant wrote: ... > sequence of values in each iteration of the for loop. ... > please guide me as to what is the best way to utilize RAND function ...
    (comp.soft-sys.matlab)
  • Re: random integer
    ... There is no such thing as a standard rand(); ... Each vendor is allowed ... The rand function computes a sequence of pseudo-random ... The rand function returns a pseudo-random integer. ...
    (comp.programming)
  • Re: random is not random enough?
    ... > stop the program and re-run it, the same sequence is produced. ... That is that under the hood this random calls srand once and then calls ... rand after that. ... The rand function is a pseudo random generator. ...
    (comp.lang.c)