Random Selection of Some Lines in Excel Worksheet

[jeannie v]

Greetings Experts:

I now have another function to perform and don't know how or if it is
possible....

I have 250 records, but I need to randomly select 110 of them...this will
occur each month, trying to not get the same records to be audited...is this
even possible?

Thank you for your help,

 

[Pete_UK]

In a helper column adjacent to your records you could put the formula:

=RAND()

and copy this down the column to cover your 250 records. Then you can
sort all the data including this helper column, using the helper
column as the key (the values might change, but that doesn't matter).
Then choose the first 110 records.

Hope this helps.

Pete

 

[jeannie v]

Pete: Many thanks for your expertise....It works exactly as I wanted it to.

 

[Pete_UK]

Thanks for feeding back, Jeannie - glad to be of help.

Pete