Results 1 to 11 of 11

Code to randomize within a filter

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-18-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    104

    Code to randomize within a filter

    I was presented a scenario from my boss and was wondering if somebody could help me out. My sample spreadsheet attached has only 1,500 records but the actual one has about 10,000 records and was wondering if there was a code to help me reduce my sample.

    I was asked to find a way to find a way where I could randomly select 2 records for each client. The catch is that the 2 records have to be different states.

    To further complicate things, I have to do this once a month and for each month, I need records on states that have yet to be selected until all 50 states are selected, and then the process starts over again.

    I was wondering if there was a code that could me with at least some of this process but any ideas, suggestions, comments, anything would be greatly appreciated. I don't know where to start.

    Thanks!
    Scott
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Code the saves filter info to reapply after running other code
    By Wedge120 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-25-2011, 05:49 PM
  2. Randomize
    By Valkyrie1981 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-22-2010, 11:27 AM
  3. Randomize
    By shaun0_0 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 09-12-2008, 02:24 PM
  4. Randomize
    By CobraLAD in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-19-2008, 06:46 AM
  5. [SOLVED] Randomize
    By Davor ®upaniæ in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2005, 02:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1