Results 1 to 3 of 3

Thread: Index match function?

  1. #1

    Index match function?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Guys,

    Can you please help me what function to use im so confused i have the logical idea but cannot implement the function.
    I want to display the last name and first name of employees who has no middle name and whose gross pay is the maximum.
    Last Name First Name Middle Name Gross Pay
    Anapen Annie 50,000
    Croker Charlie 35,000
    Jo John J 15,000

    Hoping for your advice
    Thanks

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    869
    Articles
    0
    Excel Version
    Excel 2013
    Try ARRAY formula (the formula is complete with Ctrl+Shift+Enter)
    Pay attention, you may need to use a comma instead of a semicolon
    Code:
    =INDEX($A$2:$A$10&" ";MATCH(MAX(IF($C$2:$C$10=0;$D$2:$D$10));$D$2:$D$10;0))&INDEX($B$2:$B$10;MATCH(MAX(IF($C$2:$C$10=0;$D$2:$D$10));$D$2:$D$10;0))
    Please see attach
    Attached Files Attached Files
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  3. #3
    Wizard Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,615
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Cross posted on EF without links

    Please read http://www.excelguru.ca/content.php?184

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •