Results 1 to 3 of 3

Thread: Function to Sort data based on value to the right

  1. #1
    Board Regular
    Join Date
    Sep 2018
    Posts
    110
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Function to Sort data based on value to the right

    A 10
    B 5
    C 20
    D 1
    E 13
    F 15
    G 18
    H 2
    I 6
    J 7


    Using the above table column A is an array Function that pulls data from another sheet which will Every time I sort Column B to Sort A to Z it always goes back to the normal Sort. I want column C to pull the data form Column A and List them based on the order of the number to the right so. So Results for Column C Should be as Follows:

    D
    H
    B
    I
    J
    A
    E
    F
    G
    C
    Last edited by hajiali; Sep 10th, 2019 at 04:00 PM.

  2. #2
    Board Regular Toadstool's Avatar
    Join Date
    Mar 2018
    Posts
    230
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Function to Sort data based on value to the right

    As long as your data won't have duplicates, as in your example, then this will work:

    A B C
    1 A 10 D
    2 B 5 H
    3 C 20 B
    4 D 1 I
    5 E 13 J
    6 F 15 A
    7 G 18 E
    8 H 2 F
    9 I 6 G
    10 J 7 C
    hajiali

    Worksheet Formulas
    Cell Formula
    C1 =INDEX($A$1:$A$10,MATCH(AGGREGATE(15,6,$B$1:$B$10,ROW()),$B$1:$B$10,0))
    Life advice found on a book of matches: "Keep cool. Keep away from children."

  3. #3
    Board Regular
    Join Date
    Sep 2018
    Posts
    110
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Function to Sort data based on value to the right

    Thank you Toadstool. works Great

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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