View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ray Ray is offline
external usenet poster
 
Posts: 267
Default Random selections with criteria

Thanks Joel ... I'll give it a try!

One question: the % of entries audited should INCLUDE the pre-
filtered lines. So, if we want 12% (cell b1) of 1000 entries, that's
120 lines to be audited. If the pre-filter (# of Invoices & Invoice
Amts) yields 20 lines, 100 entries should be randomly selected. If
the pre-filter yields 30 lines, then 90 rows would be selected. How
would I modify your code to use this logic?

Thanks again,
ray