Results 1 to 4 of 4

How to rank while comparing 2 cells

Threaded View

yusriza How to rank while comparing 2... 03-17-2015, 11:32 PM
Tsjallie Re: How to rank while... 03-23-2015, 06:49 AM
yusriza Re: How to rank while... 03-23-2015, 09:55 AM
Tsjallie Re: How to rank while... 03-23-2015, 03:46 PM
  1. 03-17-2015, 11:32 PM #1
    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
« 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