+ Reply to Thread
Results 1 to 3 of 3

Excel Match Help

  1. 10-05-2014, 08:18 PM #1
    JakeMuzz
    JakeMuzz is offline
    Registered User
    Join Date
    10-05-2014
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Excel Match Help

    Heya Guys,

    I'm fairly new to the whole excel concept so would appreciate all the help i could get.

    I have a table I am working on where i am pulling names and data to find the lowest efficiencies.
    However with my formula i am using it is only pulling the first possible match.
    So I have bob and Jane at 67.78% and my table pulls both names as Bob however if you change Janes efficiency to 70.00%, the table will pull up the correct names.
    Is it possible to change the formula to find the second match if there was duplicates?
    Efficiency Match.xlsx

    Cheers,
    Reply With QuoteRegister To Reply
  2. 10-05-2014, 08:41 PM #2
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Excel Match Help

    Yes, there are formulas that will do, a bit complex to read, but doable. However Excel has a simple Pivot Table tool that create this table for you as well.

    Here's a video showing me putting your bottom 5 efficiencies in a table that looks like the one you created.

    http://screencast.com/t/Qfwh7ylhg

    I just realized the video shows a (Blanks) option that wouldn't be there if I simply selected the cells with data in them at the start.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)
    Reply With QuoteRegister To Reply
  3. 10-05-2014, 08:59 PM #3
    JakeMuzz
    JakeMuzz is offline
    Registered User
    Join Date
    10-05-2014
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Excel Match Help

    Awesome Thank you JBeaucaire!
    Absolute life saver
    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. [SOLVED] Excel bug? Excel calculated Polynomial formula does not match data, why?
    By Doug_mkk in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 02-13-2020, 11:36 AM
  2. [SOLVED] Two Excel sheets trying to match text data and return the match from the second column!
    By bankcott in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-02-2013, 02:17 PM
  3. [SOLVED] Index/Match/Match....Stops without completing the match
    By irsles in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-14-2012, 10:16 PM
  4. Excel Help Page Doesn't Match Excel (Date Category Axis Base Unit)
    By PMH in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 05-11-2012, 09:20 AM
  5. Index/Match/Match. Formula looking veritcal and horizontal headings to find a match
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-29-2012, 08:51 PM

Tags for this Thread

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