Results 1 to 21 of 21

=LARGE with multiple dynamic criteria

Threaded View

  1. #1
    Registered User
    Join Date
    10-24-2017
    Location
    london
    MS-Off Ver
    2016
    Posts
    10

    =LARGE with multiple dynamic criteria

    Good afternoon all,

    Thank you in advance for your help.

    I've attached a file I'm working on currently.

    I would like the top 20 campaign names to populate dependent on the highest value metric selected from G3 (currently revenue). G3 would reference the revenue column (F) in Raw data, but would need to be interchangeable with column C-G (traffic, cost etc)

    The campaigns and weekly metrics would then change dependent on that particular campaigns specified metric that week.

    Thanks,
    Joe
    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] INDEX MATCH & LARGE functions, multiple criteria
    By abulkhairi in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-11-2017, 01:20 AM
  2. [SOLVED] INDEX MATCH LARGE with Multiple criteria
    By clachi80 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-14-2017, 03:50 AM
  3. [SOLVED] SUMIFS with multiple criteria WITH specified dynamic range criteria
    By dluhut in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-20-2017, 11:03 AM
  4. Formula for summing on multiple row criteria and a dynamic column criteria
    By ianswilson815 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-25-2016, 01:58 PM
  5. [SOLVED] LARGE Function with multiple criteria
    By andrewc in forum Excel General
    Replies: 3
    Last Post: 03-11-2014, 07:57 AM
  6. Excel 2007 : Index, Match, Large Formula: Multiple Criteria, Multiple Ranges
    By SimpleJack in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-19-2013, 08:54 AM
  7. Excel 2008 : DSUM or SUBTOTAL with Dynamic Criteria from a Large List
    By friedland_industries in forum Excel General
    Replies: 7
    Last Post: 07-27-2011, 03:08 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