Results 1 to 9 of 9

Syntax for LARGE with criteria using OR

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-10-2005
    MS-Off Ver
    2007
    Posts
    223

    Syntax for LARGE with criteria using OR

    Hi,
    I have column M with security type and column N with percentages. My goal is to get the largest, second-largest, etc. percentage if the security type is Equity or Fixed. I tried a lot of variations but cannot get it to work. Here's one of the things I tried:

    =LARGE(IF($M$30:$M$500=OR("Equity","Fixed")),$N$30:$N$500),1)

    Any help would be appreciated.
    Thanks,
    Phillycheese
    Last edited by Phillycheese5; 11-21-2014 at 02:52 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. use large function with sum criteria
    By rishikrsaw in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-24-2014, 05:00 PM
  2. Match with Muliple Criteria VBA Syntax Issue
    By beat in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-23-2013, 09:13 AM
  3. Large function with if criteria
    By ronleex324 in forum Excel General
    Replies: 6
    Last Post: 03-20-2009, 02:30 PM
  4. DCOUNT-criteria syntax for counting blank cells
    By onin111 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-29-2008, 06:37 AM
  5. Syntax for IF with multiple criteria
    By SueJB in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-20-2005, 02:47 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