+ Reply to Thread
Results 1 to 4 of 4

Large Function on subset of data

  1. 04-10-2021, 06:25 PM #1
    jkgator99
    jkgator99 is offline
    Registered User
    Join Date
    04-10-2021
    Location
    Atlanta, Ga
    MS-Off Ver
    2019
    Posts
    2

    Large Function on subset of data

    I have an excel formula using the Large function to find the largest values of my dataset:
    Please Login or Register  to view this content.
    What I am trying to do is find the largest value from a smaller subset that is defined by another column, i.e. Col J >20. Any help would be greatly appreciated.
    Reply With QuoteRegister To Reply
  2. 04-10-2021, 06:58 PM #2
    protonLeah
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: Large Function on subset of data 

    Please Login or Register  to view this content.
    **Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts braces {} around the formula (though do not attempt to manually insert these yourself).
    Attached Files Attached Files
    Ben Van Johnson
    Reply With QuoteRegister To Reply
  3. 04-10-2021, 07:25 PM #3
    Phuocam
    Phuocam is online now
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,913

    Re: Large Function on subset of data

    Or try:

    =MAXIFS(P:P,J:J,">20")
    Reply With QuoteRegister To Reply
  4. 04-10-2021, 08:10 PM #4
    jkgator99
    jkgator99 is offline
    Registered User
    Join Date
    04-10-2021
    Location
    Atlanta, Ga
    MS-Off Ver
    2019
    Posts
    2

    Re: Large Function on subset of data

    This works great. Thanks!
    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. [SOLVED] Get a subset of large table with only top values
    By saravnepali in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-01-2020, 08:44 AM
  2. Large function returns #value error =large(b13:b607,1) referenced cellls are result of for
    By LLOYDT1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-19-2018, 04:47 PM
  3. [SOLVED] Narrowing the data using the LARGE function
    By Saturn in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-10-2015, 12:47 AM
  4. How to simultaneosly show a subset of cells based on any one of the cells in the subset
    By pltrapper in forum Excel General
    Replies: 2
    Last Post: 09-25-2013, 09:53 AM
  5. Need a macro to calculate =count =avg =stdev of each subset for a large set of data
    By gabriellucero in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 07-20-2012, 02:06 PM
  6. Using AVERAGEIFS function to average a smaller subset of criteria data
    By RJS5062 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-22-2012, 04:19 PM
  7. [SOLVED] How to enter symbols for subset or element of a subset in Excel?
    By rwcita in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-23-2006, 05:30 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1