Return two random lines

J

Jeremy

I need to randomly select two lines per person listed on my report. How can
I do this?
 
S

smartin

Jeremy said:
I need to randomly select two lines per person listed on my report. How can
I do this?

Without seeing what you are working with I cannot say exactly.

=INT(1+RND()*x)

will generate a random number between 1 and x.

If you are using Excel 2007 (or prior version with analysis toolpack)
you can use

=RANDBETWEEN(1,x)

Use such random numbers to pick the lines you want to inspect.
 

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

Top