Dazed,

Insert a column of formulas, like this (assumes that the amount is in column D, for example)

=OR(D2=5000,(Rand()*100)99)

Change the 99 to a lower number to choose a greater # of items randomly... Then filter your
database based on the column of formulas, and choose to show TRUE. The transactions still visible
are those that should be reviewed.

HTH,
Bernie
MS Excel MVP


"dzd&confused" wrote in message
...
I need a statistically valid, randomly selected breakout of transactions from
a total population of all transactions. Would like to have Excel generate a
statistically valid list from a total population of about 38K transactions.
All 38K transactions, regardless of dollar value, are subject to review
through random selection based on the n of total population. The list should
also incude any transaction = $5,000. The listing should include all data
elements of the select transactions.

Possible? How?