Random Selection of Some Lines in Excel Worksheet
 

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,
--
jeannie v

Random Selection of Some Lines in Excel Worksheet
 

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

On Dec 13, 7:48 pm, jeannie v
wrote:
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,
--
jeannie v

Random Selection of Some Lines in Excel Worksheet
 

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


"Pete_UK" wrote:

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

On Dec 13, 7:48 pm, jeannie v
wrote:
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,
--
jeannie v

Random Selection of Some Lines in Excel Worksheet
 

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

Pete

On Dec 14, 12:01 am, jeannie v
wrote:
Pete: Many thanks for your expertise....It works exactly as I wanted it to.
--
jeannie v



"Pete_UK" wrote:
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

On Dec 13, 7:48 pm, jeannie v
wrote:
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,
--
jeannie v- Hide quoted text -

- Show quoted text -