Results 1 to 12 of 12

Index Match Large Duplicate Values

Threaded View

  1. 09-21-2017, 02:25 AM #1
    lalahaedong_excel
    lalahaedong_excel is offline
    Registered User
    Join Date
    09-13-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    45

    Index Match Large Duplicate Values

    I have an IndexMatch multiple criteria that i need to Match and then solve for the 2nd largest value. I have tried everything ...nothing is working
    Im trying to match the Location and Month and then show the 2nd largest Usage value




    Could anyone help with this...ive been up for hours trying to fix this...
    Attached Files Attached Files
    Last edited by lalahaedong_excel; 09-22-2017 at 01:00 PM.
    Reply With QuoteRegister To Reply
« 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] Index Match Large Duplicate Values
    By auxaurores in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-12-2016, 05:02 AM
  2. Match and Index with Duplicate values
    By shortracer5 in forum Excel General
    Replies: 1
    Last Post: 09-09-2016, 05:25 AM
  3. [SOLVED] Handling Duplicate Entries with Index/Match/Large in Column Data
    By TwiceBorn in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-12-2016, 02:11 PM
  4. Index Match & Duplicate values
    By Shaulyt in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-13-2016, 05:23 PM
  5. [SOLVED] INDEX, MATCH & LARGE trouble with duplicate values
    By paulstuartbullock in forum Excel General
    Replies: 4
    Last Post: 08-04-2015, 11:17 PM
  6. [SOLVED] Help with Index/Match/Large problem with duplicate values
    By enphynity in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-31-2013, 09:56 AM
  7. Index, Match, Large Function returning duplicate names
    By RNeel55 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-08-2013, 04:09 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