+ Reply to Thread
Results 1 to 2 of 2

Sorting by column when random

  1. #1
    Registered User
    Join Date
    01-08-2019
    Location
    Milton
    MS-Off Ver
    2016
    Posts
    2

    Post Sorting by column when random

    So a basic example of my problem is
    I have my data like this

    e 8
    x 5
    y 3


    but I actually want it to be ordered by a column I already have that is (a random order)

    x
    y
    e

    Is there a way to map values across so that

    e 8 x 8
    x 5 becomes y 3
    y 3 e 8


    To sum up.
    I have my number in a order with multiple columns.
    I want to sort by another column that is the same as the 1st column but in a random order

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Sorting by column when random

    If your data is in columns A and B (it is always a good idea to give more detail about how your data is organized), and the column you already have (that is in a random order) is in column C, and the values in column A are unique, then you can put this in column D, starting in row 1 and copying down:

    =VLOOKUP(C1,A:B,2,FALSE)
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 08-07-2018, 09:25 AM
  2. [SOLVED] Random sorting in groups?
    By johandenver in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-18-2017, 07:49 PM
  3. Sorting random Data
    By mahmoodadeel in forum Excel General
    Replies: 2
    Last Post: 09-30-2014, 11:05 PM
  4. Assigning Random number and sorting
    By ajang in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-28-2014, 10:31 PM
  5. Random Sorting Data
    By Sharp in forum Excel General
    Replies: 1
    Last Post: 11-26-2007, 09:19 AM
  6. extracting random data and sorting into cells
    By Chico in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-10-2007, 03:00 PM
  7. cells random sorting
    By patje in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-08-2007, 05:30 AM

Tags for this Thread

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