+ Reply to Thread
Results 1 to 32 of 32

Ranking numbers with additional criteria

Hybrid View

  1. #1
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Ranking numbers with additional criteria

    Sorry - have absolutely no knowledge of Google Docs.

    The logic is, basically:

    1) Since 4 numbers must come from the first group (of 10), then find the 4 largest numbers in that group. Mark with "X".
    2) Since 2 numbers must come from the second group (of 5), then find the 2 largest numbers in that group. Mark with "X".
    3) Since 2 numbers must come from the third group (of 5), then find the 2 largest numbers in that group. Mark with "X".
    4) Find the 2 largest numbers in the entire set that do not already form part of either 1), 2) or 3) above. Mark with "X".

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  2. #2
    Registered User
    Join Date
    08-14-2013
    Location
    Aus
    MS-Off Ver
    Excel 2011 for Mac
    Posts
    27

    Re: Ranking numbers with additional criteria

    I was under the impression it was almost identical, but I guess it does have differences. Thanks again for your help!
    Last edited by JBeaucaire; 08-16-2013 at 09:02 AM. Reason: Removed unnecessary whole post quote

+ 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. [SOLVED] Using substitute with with additional criteria
    By tryer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-08-2012, 06:27 PM
  2. RC Notation and additional criteria
    By mkc80 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-05-2012, 04:35 PM
  3. [SOLVED] Vlookup with additional criteria
    By coolzero in forum Excel General
    Replies: 14
    Last Post: 09-20-2012, 10:45 AM
  4. Replies: 8
    Last Post: 07-12-2010, 08:52 AM
  5. Sum Data Using Dates and Additional Criteria
    By kgibson20 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-29-2008, 04:59 PM

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