Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Select a random sample | Excel Discussion (Misc queries) | |||
How do I select the first cell of a filtered list? | Excel Worksheet Functions | |||
Select data in filtered list | Excel Discussion (Misc queries) | |||
How do I create a random sample from a list? | Excel Worksheet Functions | |||
How do I pull a random sample of people from a list in excel? | Excel Worksheet Functions |