select random sample of records in a filtered list

D

David3553

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
 

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

Similar Threads

summing data from a list 2
Space at end of multi page list to accommodate new entries 1
Select random records by two conditions 1
find -> list of records 2
Random table of data - need to find every cell that contains specific data 1
Filtered drop down list 2
Creating a Search using a combo box and then creating a report. 4
VBA Pivot Table Error 1

Top