Results 1 to 5 of 5

LARGE( IF( AND( condition A; condition B);Array);rank)

Threaded View

  1. #1
    Registered User
    Join Date
    11-26-2019
    Location
    Geneva
    MS-Off Ver
    10
    Posts
    6

    LARGE( IF( AND( condition A; condition B);Array);rank)

    Hi team, I am trying to sort by weight an equity index through sector and subsector.

    Formula is ={LARGE(IF(AND($C:$C=$G3;$D:$D=$H3);$E:$E);1)} where in column C are sectors, column D subsectors, column E index weight.

    It doesn't work though. Your help is very welcome. I attach spreadsheet sample.

    Best,
    XL
    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] Trying to use a formula to rank with a condition
    By tonym33 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 11-26-2019, 11:02 AM
  2. [SOLVED] How To Rank Or Create A Top 5 Count / Rank With If Condition
    By PaddyP in forum Excel General
    Replies: 10
    Last Post: 05-14-2019, 03:04 PM
  3. [SOLVED] Rank formula based on condition
    By shrijan in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 09-01-2016, 08:22 AM
  4. [SOLVED] Sum Large values along with Count Condition - Array Formula
    By acsishere in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-28-2013, 05:45 PM
  5. How to use Rank with 2 Condition
    By wpm7113 in forum Excel General
    Replies: 4
    Last Post: 06-25-2008, 02:53 PM
  6. rank function on condition
    By David Obeid in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-07-2008, 02:23 AM
  7. Rank with condition
    By R. Choate in forum Excel General
    Replies: 12
    Last Post: 04-26-2006, 10: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