View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David3553 David3553 is offline
external usenet poster
 
Posts: 6
Default select random sample of records in a filtered list

I have an excel 2007 table that contains records of financial transactions. I
want to select a sample of n records (usually 10 but may vary) from a subset
of the transactions. For example, from a list that contains all transactions
for the entire year:

Randomly select 10 records for the month of September with a transaction
amount greater than $50,000 from the list.

Where the list would contain one column with the month and another column
with the transaction amount.

Any thoughts on how I can accomplish this?

Thanks,

David