+ Reply to Thread
Results 1 to 5 of 5

Randomly alter a column of names

  1. #1
    Scudo
    Guest

    Randomly alter a column of names

    I have a list of place names in column A from row 1 to row 56
    Its part of a game so all I want to do is alter the order of names (randomly
    if possible)
    There is only one column which is the one with the names in it.

    thnaks



  2. #2
    Max
    Guest

    Re: Randomly alter a column of names

    One way ..

    Names are assumed in col A, in A1:A20, say

    Put in C1: =RAND()

    Put in B1: =INDEX(A:A,MATCH(SMALL(C:C,ROWS($A$1:A1)),C:C,0))

    Select B1:C1, copy down to C20

    You'd get a random scramble of the names from col A in col B

    Press F9 to re-generate afresh
    --
    Rgds
    Max
    xl 97
    ---
    Singapore, GMT+8
    xdemechanik
    http://savefile.com/projects/236895
    --
    "Scudo" <me@nospam.fictional> wrote in message
    news:s2sZe.6864$lL1.1662@fe1.news.blueyonder.co.uk...
    > I have a list of place names in column A from row 1 to row 56
    > Its part of a game so all I want to do is alter the order of names

    (randomly
    > if possible)
    > There is only one column which is the one with the names in it.
    >
    > thnaks
    >
    >




  3. #3
    Tushar Mehta
    Guest

    Re: Randomly alter a column of names

    For a few different options see
    Random Selection
    http://www.tushar-mehta.com/excel/ne...ion/index.html

    --
    Regards,

    Tushar Mehta
    www.tushar-mehta.com
    Excel, PowerPoint, and VBA add-ins, tutorials
    Custom MS Office productivity solutions

    In article <s2sZe.6864$lL1.1662@fe1.news.blueyonder.co.uk>,
    me@nospam.fictional says...
    > I have a list of place names in column A from row 1 to row 56
    > Its part of a game so all I want to do is alter the order of names (randomly
    > if possible)
    > There is only one column which is the one with the names in it.
    >
    > thnaks
    >
    >
    >


  4. #4
    Max
    Guest

    Re: Randomly alter a column of names

    > .. names in column A from row 1 to row 56

    > Select B1:C1, copy down to C20


    If you have 56 names in A1:A56,
    just select B1:C1 and copy down to C56
    to get the full scramble in col B
    --
    Rgds
    Max
    xl 97
    ---
    Singapore, GMT+8
    xdemechanik
    http://savefile.com/projects/236895
    --



  5. #5
    Scudo
    Guest

    Re: Randomly alter a column of names

    Thanks for the info......now sorted


    "Tushar Mehta" <tmUnderscore200310@tushar-mehta.SeeOhEm> wrote in message
    news:MPG.1da093643e6d92998b1f2@msnews.microsoft.com...
    > For a few different options see
    > Random Selection
    > http://www.tushar-mehta.com/excel/ne...ion/index.html
    >
    > --
    > Regards,
    >
    > Tushar Mehta
    > www.tushar-mehta.com
    > Excel, PowerPoint, and VBA add-ins, tutorials
    > Custom MS Office productivity solutions
    >
    > In article <s2sZe.6864$lL1.1662@fe1.news.blueyonder.co.uk>,
    > me@nospam.fictional says...
    > > I have a list of place names in column A from row 1 to row 56
    > > Its part of a game so all I want to do is alter the order of names

    (randomly
    > > if possible)
    > > There is only one column which is the one with the names in it.
    > >
    > > thnaks
    > >
    > >
    > >




+ 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