+ Reply to Thread
Results 1 to 3 of 3

Formula - Index / Match / Large

  1. 03-10-2015, 07:14 AM #1
    jsneak
    jsneak is offline
    Forum Contributor
    Join Date
    08-22-2013
    Location
    Sheffield
    MS-Off Ver
    Excel 2010
    Posts
    161

    Question Formula - Index / Match / Large

    Morning All,

    I have been trying to get this work all morning and when i thought i had done it.. i got a new problem! I have the same highest number in a range of data, which looks up the row above.

    Is it possible for a formula to ignore the first highest number?

    Book2.xlsx

    Sorry is this sounds complicated, any help on this would be awesome!

    Thanks
    Reply With QuoteRegister To Reply
  2. 03-10-2015, 07:44 AM #2
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Formula - Index / Match / Large

    Try replacing the (last) zero(0) in your INDEX & MATCH formula with 1.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.
    Reply With QuoteRegister To Reply
  3. 03-10-2015, 07:46 AM #3
    jsneak
    jsneak is offline
    Forum Contributor
    Join Date
    08-22-2013
    Location
    Sheffield
    MS-Off Ver
    Excel 2010
    Posts
    161

    Re: Formula - Index / Match / Large

    Worked perfect, absolute legend!

    Thank you so much
    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. Simplifying Large Index Match Formula down
    By midwest trader in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-10-2014, 09:07 PM
  2. Index Match with Large and If Formula - Not Working
    By richoconnor in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-07-2014, 10:37 AM
  3. VLOOKUP or INDEX/MATCH Formula that uses LARGE, IF, and OR
    By tj2434 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-24-2014, 10:16 AM
  4. [SOLVED] Index/Match using Large Formula
    By Steve0492 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-20-2013, 04:08 AM
  5. Large, Small, Index, Match formula combos
    By taudano in forum Excel General
    Replies: 2
    Last Post: 06-30-2011, 01:53 AM

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