ExcelBanter - Return two random lines

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Return two random lines (https://www.excelbanter.com/excel-worksheet-functions/228373-return-two-random-lines.html)

Jeremy

Return two random lines

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

smartin

Return two random lines

Jeremy wrote:
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.

All times are GMT +1. The time now is 12:18 AM.