+ Reply to Thread
Results 1 to 4 of 4

Ranking formula across columns

  1. 09-26-2020, 10:17 AM #1
    SJB777
    SJB777 is offline
    Registered User
    Join Date
    02-22-2013
    Location
    Workington
    MS-Off Ver
    Excel 2010
    Posts
    35

    Ranking formula across columns

    Hello, I'm hoping for some advice as to how to rank across a columns.

    e.g. if A1 = 1, and B1 = 2 I would like to be able to show in cell A3, that A1 is ranked number 2, because it has fewer points than B1.

    I've attached an example to explain in further detail, with my attempted formula in D41.

    Many thanks in advance.

    Steve
    Attached Files Attached Files
    Last edited by SJB777; 09-26-2020 at 10:44 AM.
    Reply With QuoteRegister To Reply
  2. 09-26-2020, 10:20 AM #2
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,078

    Re: Ranking formula across columns

    How about
    =RANK(D35,($D$35:$AO$35),0)
    Reply With QuoteRegister To Reply
  3. 09-26-2020, 10:43 AM #3
    SJB777
    SJB777 is offline
    Registered User
    Join Date
    02-22-2013
    Location
    Workington
    MS-Off Ver
    Excel 2010
    Posts
    35

    Re: Ranking formula across columns

    Perfect, thank you very much - thought I was close! Much appreciated.
    Reply With QuoteRegister To Reply
  4. 09-26-2020, 10:53 AM #4
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,078

    Re: Ranking formula across columns

    Glad to help & thanks for the feedback.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Ranking the results of an array formula without help columns
    By josepvv in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-05-2018, 02:14 AM
  2. [SOLVED] Ranking formula based on values in multiple columns taken from a different sheet
    By m_t in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-15-2016, 03:52 PM
  3. [SOLVED] Ranking Help - Rank formula to exclude data from ranking (like a rank if kind of function)
    By harp1983 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-08-2016, 06:55 PM
  4. Ranking in columns
    By SWLover123456 in forum Excel General
    Replies: 15
    Last Post: 05-18-2011, 11:51 PM
  5. Ranking from 3 or more columns
    By manster in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-11-2009, 04:06 PM
  6. ranking by 3 columns
    By reggie1000 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-24-2008, 01:59 PM
  7. [SOLVED] ranking columns
    By Tom Donino in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-19-2005, 02:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1