how to randomly select data in excel

G

Guest

how do we select a small sample of data randomly froma given set of large
data in excel
 
G

Guest

Hi,

I have just seen the solution to the query at the site mentioned below.

I tried this formula [Worksheet Method 2: Using SMALL() with a helper column
] but I just got only 1 random number in column C1........where as I was
expecting 4 random numbers to be displayed in column C1:C4

Please could you explain where I could have gone wrong.

I wanted similar solution to one of my query........where out of set of 100
questions I want randomly selected 20 questions each time.

Hope to here solution to my query.....
Cheers,
Mandeep Dhami
 
G

Guest

Thanks JE this formula works.

JE McGimpsey said:
Did you have 4 cells selected when you array-entered the formula?

Mandeep Dhami said:
I tried this formula [Worksheet Method 2: Using SMALL() with a helper column
] but I just got only 1 random number in column C1........where as I was
expecting 4 random numbers to be displayed in column C1:C4
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What is the function to randomly select a cell, like for lottery? 1
How can i randomly select 780 rows from 4000 rows of data 2
Lottery function - how to randomly select cells 1
Select from a list 2
Selecting Random Records From an Excel Sreadsheet 3
How do I automatically select a Excel record randomly? 3
How do I get excel to generate Random nos for my data? 2
Select a random sample 2

Top