+ Reply to Thread
Results 1 to 2 of 2

Want to link ranked of cells in 1 column w/values in corresponding cells of another column

  1. #1
    Registered User
    Join Date
    11-01-2013
    Location
    Olympia, Washington
    MS-Off Ver
    Excel 2007
    Posts
    37

    Want to link ranked of cells in 1 column w/values in corresponding cells of another column

    Attached is work book 5.

    What I am trying to do now is:

    The ranking in column C of 10 numbers (this can be as high as 15 numbers)

    10
    03
    06
    09
    04
    01
    05
    08
    07
    02

    The values in column E:

    05
    -08
    03
    -10
    07
    07
    -15
    8
    0
    -11

    I am trying to get the corresponding cell number in column E to line up next to its partner in column C .

    Example:

    Column C states that cell number 10 is the highest ranked value.
    I would like to get the value of cell number 10 in column E to be listed in column D cell 1.

    10 ... - 11
    03 ... 03
    06 ... 07
    09 ... 00
    04 ... - 10
    01 ... 05
    05 ... 07
    08 ... 08
    07 ... - 15
    02 ... - 08
    Attached Files Attached Files
    Last edited by Securitysports; 11-03-2013 at 05:29 PM.

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Want to link ranked of cells in 1 column w/values in corresponding cells of another co

    In cell D1 put =INDEX(E$1:E$10,C1) and copy down.

+ 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: 4
    Last Post: 01-07-2015, 08:29 PM
  2. Replies: 1
    Last Post: 03-02-2013, 05:06 AM
  3. [SOLVED] Rule to find cells in column A that correspond to multiple values in column B
    By margaretanne in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-11-2013, 07:24 PM
  4. Average range of cells in column if values in adjacent column are equal
    By RyNye in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-09-2012, 10:12 AM
  5. Sum ranked values in nonadjacent cells
    By mashley in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-24-2007, 07:42 PM

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