Select Random Number from List

[dreicer_Jarr]

Say I have a list of 100 numbers (in column A). What formula would I use to have Excel list (in column B) 50 random numbers from the list of 100 or column A?

Thank you in advanced,

D

[shg]

In an unused column, =RAND() and copy down. Sort by that column and choose the first 50.

[dreicer_Jarr]

I am missing something. The Rand() function will give me a random number between 0 to 1, but I want 50 random numbers from a list which I have in a separate column (column A). Does that make sense?

[shg]

The point of the random numbers is to randomly order the list when sorted. Choose the first 50 from any column you like.

[dreicer_Jarr]

Nevermind, I just got what you are saying. The problem is that I don't want to be sorting this table continually as this report is meant to be automatic. There must be a way to just choose 50 random numbers from a column (aka the main column) without sorting (or setting up a macro to automatically sort). The main column will continually be changing and so I don't want to be sorting on a regular basis. Make sense?

[shg]

=INDEX(A1:A100, MATCH(SMALL(B1:B100, ROW()), B1:B100, 0))

... where A contains your values of interest, and B contains random numbers.

[dreicer_Jarr]

I wish I had your brain. Thanks.