+ Reply to Thread
Results 1 to 18 of 18

Retrieving ranking by looking at 2 criteria

Hybrid View

  1. 09-09-2018, 01:58 PM #1
    Fluff13
    Fluff13 is online now
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,740

    Re: Retrieving ranking by looking at 2 criteria

    With a helper column
    =VALUE(B2&24-HOUR(C2))
    Then
    =INDEX(A$2:A$5,MATCH(LARGE(E$2:E$5,1),E$2:E$5,0))
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-09-2018, 02:31 PM #2
    Keebellah
    Keebellah is offline
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,937

    Re: Retrieving ranking by looking at 2 criteria

    Try this one, the value in column B is not a string but a number
    Attached Files Attached Files
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you
    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 Question - Ranking based criteria but having forumla value issues
    By harp1983 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-09-2016, 07:03 AM
  2. Retrieving Data that meets a certian criteria
    By Otaishtf in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-26-2013, 03:43 AM
  3. Retrieving Data Based on Two Criteria and Two Worksheets
    By ERabbit in forum Excel General
    Replies: 7
    Last Post: 08-26-2011, 06:00 PM
  4. Excel 2007 : Retrieving Data Based on Two Criteria and Two Worksheets
    By ERabbit in forum Excel General
    Replies: 0
    Last Post: 08-25-2011, 01:59 PM
  5. Retrieving an Item from a List that Meets Multiple Criteria
    By hgopp99 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-21-2006, 11:10 AM
  6. Retrieving a Value from List that meets multiple Criteria
    By mamalik in forum Excel General
    Replies: 3
    Last Post: 01-02-2006, 10:30 AM
  7. Retrieving an Item from a List that Meets Multiple Criteria
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-25-2005, 02:59 AM

Tags for this Thread

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