Results 1 to 8 of 8

Unique list with criteria and ranking

Threaded View

  1. #1
    Forum Contributor TechRetard's Avatar
    Join Date
    06-14-2009
    Location
    Houston, TX
    MS-Off Ver
    Excel 2010
    Posts
    202

    Unique list with criteria and ranking

    Need some help with a unique list. I have data in 3 columns as shown below

    Names Year Rank
    John 2020 1
    Kevin 2021 5
    Mary 2022 4
    Ann 2021 3

    i want a unique table for each year, to show the Names, but in rank order, as shown below

    what formula should i put in first cell (i.e. where John is)? I am able to get this table but without rank order, and i can get a 1 column table with all of the unique names in rank order, just can't figure out how to combine :/

    2020 2021 2022
    John Ann Mary
    Kevin
    Last edited by TechRetard; 10-30-2020 at 03:57 PM.
    TechRetard.ToString();

    There are always multiple ways to do something, when it doubt, drink a beer.

    I do not care if you rep or not but please mark post as Solved if there is resolution so I stop going back and checking if anything else is needed.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 08-08-2019, 02:28 AM
  2. [SOLVED] Rank multiple criteria unique ranking
    By silkpantsman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-12-2019, 07:54 AM
  3. Ranking using multiple Criteria but with unique rank values
    By soma1508 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-06-2018, 02:54 PM
  4. [SOLVED] Unique Ranking with Multiple Criteria
    By Chocobo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-01-2018, 01:34 PM
  5. Unique Ranking with Multiple Criteria
    By dglenski in forum Excel General
    Replies: 7
    Last Post: 05-09-2017, 01:05 AM
  6. Unique Ranking with Multiple Criteria
    By dglenski in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-09-2017, 12:09 AM
  7. Unique ranking by multiple criteria
    By reggie1000 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-21-2015, 08:03 AM

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