Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 39
Default random selection of rows

I have a master list of all of our cases--there are approximately 20000 rows,
each row representing a single case, and each row has 13 columns of data. I
filtered the list, for example, to see all of the active cases for a case
manager. Suppose that filter produces 117 cases (there are of course a
different number for each case manager). I want to create a macro or use a
formula to randomly select one of these rows as a way to randomly select
cases for audits.

Is there a way to do this?
Thanks.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Random selection of rows. chavan2000 via OfficeKB.com Excel Programming 2 January 28th 09 10:21 PM
Random Selection Erika Excel Discussion (Misc queries) 2 July 22nd 08 11:17 PM
Random Selection carl Excel Worksheet Functions 7 June 13th 08 11:12 PM
Random Selection Cookie New Users to Excel 2 May 3rd 06 12:05 AM
Random Selection Newdlj[_3_] Excel Programming 3 December 23rd 03 12:55 AM


All times are GMT +1. The time now is 08:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"