Results 1 to 2 of 2

Finding 3 largest values using LARGE function based on criteria in another column

Threaded View

cathyharland Finding 3 largest values... 01-22-2018, 11:51 PM
tim201110 Re: Finding 3 largest values... 01-23-2018, 02:17 AM
  1. #1
    Registered User
    Join Date
    01-22-2018
    Location
    Melbourne
    MS-Off Ver
    2007
    Posts
    1

    Finding 3 largest values using LARGE function based on criteria in another column

    I am trying to find the 3 largest values for each Org in the attached spreadsheet, based on the values in Column C. I want Columns D-F to contain the highest Column C value for Org A in the row for Org A, Org B for Org B etc. So for Org B, I would expect Column D to have 72, Column E to have 63 etc. Can anyone point me in the right direction please?
    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. Excel - Using Large() to Select n Largest Values With Criteria
    By RandB in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-06-2017, 05:56 PM
  2. [SOLVED] Finding values based on criteria from more than one column
    By milkychips in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-08-2015, 02:57 PM
  3. [SOLVED] Finding Values in a Column based on Criteria and Selecting Rows Above
    By LvaughnL in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-04-2013, 03:07 PM
  4. Finding Largest Value in Column B with Given Criteria in Column A
    By ichbinwesley in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-04-2013, 01:39 AM
  5. [SOLVED] Finding the largest number based on criteria
    By imerial in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-26-2013, 03:19 PM
  6. Using the LARGE function to adjust the ith largest values
    By kgbrown in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-04-2011, 06:21 AM
  7. Finding the Largest Number, based on two criteria
    By BigH in forum Excel General
    Replies: 1
    Last Post: 02-08-2006, 04:55 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