+ Reply to Thread
Results 1 to 18 of 18

Retrieving ranking by looking at 2 criteria

Hybrid View

H1dd3v Retrieving ranking by looking... 09-09-2018, 08:52 AM
Keebellah Re: Retrieving ranking by... 09-09-2018, 09:46 AM
H1dd3v Re: Retrieving ranking by... 09-09-2018, 10:35 AM
Keebellah Re: Retrieving ranking by... 09-09-2018, 11:05 AM
H1dd3v Re: Retrieving ranking by... 09-09-2018, 01:08 PM
Keebellah Re: Retrieving ranking by... 09-09-2018, 10:59 AM
H1dd3v Re: Retrieving ranking by... 09-09-2018, 01:14 PM
Fluff13 Re: Retrieving ranking by... 09-09-2018, 01:58 PM
Keebellah Re: Retrieving ranking by... 09-09-2018, 02:31 PM
Keebellah Re: Retrieving ranking by... 09-09-2018, 02:24 PM
Fluff13 Re: Retrieving ranking by... 09-09-2018, 03:05 PM
Keebellah Re: Retrieving ranking by... 09-09-2018, 03:33 PM
Fluff13 Re: Retrieving ranking by... 09-09-2018, 03:40 PM
Keebellah Re: Retrieving ranking by... 09-09-2018, 03:45 PM
H1dd3v Re: Retrieving ranking by... 09-09-2018, 06:10 PM
Keebellah Re: Retrieving ranking by... 09-10-2018, 12:51 AM
H1dd3v Re: Retrieving ranking by... 09-10-2018, 04:10 AM
Keebellah Re: Retrieving ranking by... 09-10-2018, 04:51 AM
  1. #1
    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

    I changed the format to the column B to a numeric format with a prefix
    Column C is your's to continue with
    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

  2. #2
    Registered User
    Join Date
    09-09-2018
    Location
    Enschede, Netherlands
    MS-Off Ver
    2016
    Posts
    6

    Re: Retrieving ranking by looking at 2 criteria

    I am aware of what you did -- I already posted that I knew how to do that. Integrating C into the equation so as to combine both criteria is what I struggle with. I get that it is probably an easy fix but considering that you are aware that I don't know the answer and that I ask the question, could you not bash me for it please? I don't know how to do it.

    Your usage of LARGE doesn't account for draws at all for the winner position by the way. Which is what I specifically asked.

+ Reply to 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. Replies: 7
    Last Post: 08-26-2011, 06:00 PM
  4. 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. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1