+ Reply to Thread
Results 1 to 3 of 3

How to generate a short random list from a long static list

  1. #1
    Valued Forum Contributor luv2glyd's Avatar
    Join Date
    07-13-2008
    Location
    Seattle, WA, US
    MS-Off Ver
    Excel 2010
    Posts
    679

    How to generate a short random list from a long static list

    I have a list of stock symbols in column A that is 450 rows deep. The stock symbols can be alphabetized, but I'd rather have them not alphabetized. What I'd like to do is generate a random list of 60 symbols in column C, so that every time the worksheet is recalculated, 60 randomly generated symbols appear in row C1 through C60.

    Is this possible to do somehow with a combination of lookup and randbetween formulas?
    Last edited by luv2glyd; 09-24-2010 at 12:12 PM.
    You either quit or become really good at it. There are no other choices.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How to generate a short random list from a long static list

    In another column (say, B) =RAND() and copy down 450 rows.

    In C1 and copy down 60 rows,

    =INDEX(A$1:A$450, MATCH(SMALL(B$1:B$450, ROW()), B$1:B$450, 0))
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Valued Forum Contributor luv2glyd's Avatar
    Join Date
    07-13-2008
    Location
    Seattle, WA, US
    MS-Off Ver
    Excel 2010
    Posts
    679

    Re: How to generate a short random list from a long static list

    Geat! Exactly what I need! Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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