Results 1 to 7 of 7

LARGE Function with Conditions

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-08-2005
    MS-Off Ver
    Microsoft 365
    Posts
    839

    LARGE Function with Conditions

    Hi,

    I have data arranged in columns A and B in the attached file and would like to create a formula in cell D2 that will return the largest (and the 2nd, 3rd etc largest) values from column B that are associated with AAA, CCC or DDD.

    I've had a go producing at the formula but it doesn't seem to work - I would expect the answer to be 800 for the largest value and the 2nd largest would be 700.

    Can someone please suggest how to fix my formula.

    Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Request for Excel formula for two conditions (Large to small, then small to large)
    By nicholascky in forum Excel Formulas & Functions
    Replies: 29
    Last Post: 08-14-2016, 01:16 PM
  2. Using large amount of formulas based on conditions
    By tabishali in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-31-2016, 09:30 PM
  3. large function multiple conditions
    By jaredf in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-25-2016, 12:49 PM
  4. LARGE Function with multiple conditions
    By andrewc in forum Excel General
    Replies: 5
    Last Post: 08-20-2014, 11:40 AM
  5. Excel 2007 : INDEX LARGE with two conditions.
    By jvelez198 in forum Excel General
    Replies: 2
    Last Post: 02-20-2012, 08:26 AM
  6. Replies: 9
    Last Post: 07-17-2010, 05:28 PM
  7. Sum Large with Conditions
    By mcjohn in forum Excel General
    Replies: 4
    Last Post: 09-30-2009, 12:40 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1