Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Random selection of rows. | Excel Programming | |||
Random Selection | Excel Discussion (Misc queries) | |||
Random Selection | Excel Worksheet Functions | |||
Random Selection | New Users to Excel | |||
Random Selection | Excel Programming |