+ Reply to Thread
Results 1 to 4 of 4

Can you sort text in a random order in Excel

  1. #1
    tbowden
    Guest

    Can you sort text in a random order in Excel

    I'm fairly new to excel and trying to figure out if I can sort a column of
    text in a random order. Any information would be appreicated

  2. #2
    Bernie Deitrick
    Guest

    Re: Can you sort text in a random order in Excel

    tbowden,

    If you insert a column, and fill it with formulas

    =RAND()

    to match your text, then select and sort both the text and the formulas
    based on the formula, you will have randomized your text.

    HTH,
    Bernie
    MS Excel MVP

    "tbowden" <tbowden@discussions.microsoft.com> wrote in message
    news:40BF67D9-34A4-4748-9E5C-A1C33C12FAC6@microsoft.com...
    > I'm fairly new to excel and trying to figure out if I can sort a column of
    > text in a random order. Any information would be appreicated




  3. #3
    JulieD
    Guest

    Re: Can you sort text in a random order in Excel

    Hi

    generally the way to do this is to use another column as a "helper" column
    and put a function in this column to generate random numbers and then sort
    by this column.

    to do this, choose a column adjacent to your data an in the first cell type
    =ROUND(RAND()*1000,0)
    now double click on the little fill handle (+) bottom right of cell to copy
    the formula down the column
    select this column - choose copy, edit / paste special - values OK
    to change the formula into values
    Now click in one cell only, choose data / sort - ensure that the correct
    range has been highlighted and choose to sort on this column of numbers -
    either ascending or descending.

    You can then delete the column of numbers if you like.

    Cheers
    JulieD


    "tbowden" <tbowden@discussions.microsoft.com> wrote in message
    news:40BF67D9-34A4-4748-9E5C-A1C33C12FAC6@microsoft.com...
    > I'm fairly new to excel and trying to figure out if I can sort a column of
    > text in a random order. Any information would be appreicated




  4. #4
    Bernd Plumhoff
    Guest

    Re: Can you sort text in a random order in Excel

    If you have 8 texts in cells A1:A8 you can select cells
    B1:B8, enter

    =INDEX(A1:A8,UniqRandInt(COUNTIF(A1:A8,"<>"""""),FALSE))

    (as array formula, enter with CTRL+SHIFT+RETURN), for
    example.

    You will find the function UniqRandInt() at
    www.sulprobil.com. Copy its text, press ALT+F11, insert a
    module, then paste the copied vba function text. That's
    it, I hope.

    HTH,
    Bernd

+ 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