+ Reply to Thread
Results 1 to 4 of 4

How to rank while comparing 2 cells

  1. 03-17-2015, 11:32 PM #1
    yusriza
    yusriza is offline
    Registered User
    Join Date
    03-17-2015
    Location
    Malaysia
    MS-Off Ver
    2007
    Posts
    2

    Question How to rank while comparing 2 cells

    I need favor...

    what should i do to set a rank while comparing values of 2 cells.

    Cell1 (XM Grade)

    Cell2 (Pass/Fail)

    Rank ( excellent grade/point and pass get 1st rank)

    example Point 1.4, PASS rank 1
    1.5, FAIL rank 4
    1.6, PASS rank 2
    4.4, PASS rank 3
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-23-2015, 06:49 AM #2
    Tsjallie
    Tsjallie is offline
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: How to rank while comparing 2 cells

    You'll need an extra column concatenating the 2 values and highest priority first.
    See attached example.
    Attached Files Attached Files
    Last edited by Tsjallie; 03-23-2015 at 07:00 AM.
    Cheers!
    Tsjallie



    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...
    Reply With QuoteRegister To Reply
  3. 03-23-2015, 09:55 AM #3
    yusriza
    yusriza is offline
    Registered User
    Join Date
    03-17-2015
    Location
    Malaysia
    MS-Off Ver
    2007
    Posts
    2

    Re: How to rank while comparing 2 cells

    TQ so so much.
    Reply With QuoteRegister To Reply
  4. 03-23-2015, 03:46 PM #4
    Tsjallie
    Tsjallie is offline
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: How to rank while comparing 2 cells

    You're welcome.
    If this solved your problem pls mark your thread as "Solved"
    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. [SOLVED] Priority Rank depending on blank cells w/ bypassing cells with content
    By eaflynn in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-26-2015, 01:30 AM
  2. [SOLVED] Rank string ignoring blank cells and o value cells
    By BRISBANEBOB in forum Excel General
    Replies: 3
    Last Post: 03-02-2014, 12:56 AM
  3. RANK - Non unique values, contiguous rank required cannot be found
    By ellogan in forum Excel General
    Replies: 8
    Last Post: 02-20-2014, 07:03 PM
  4. comparing lists-find each companies rank,
    By jspinx in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-25-2011, 06:10 PM
  5. Rank items, select one start date, have remaining dates follow based on rank
    By rob normerica in forum Excel General
    Replies: 1
    Last Post: 08-15-2005, 05:05 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