+ Reply to Thread
Results 1 to 4 of 4

INDEX and MATCH problem

  1. #1
    Registered User
    Join Date
    10-02-2014
    Location
    Scotland
    MS-Off Ver
    2007
    Posts
    68

    INDEX and MATCH problem

    Hello guys n girls

    For some reason I can't seem a Top 20 table to work

    In the Top 20 Data tab of a Dashboard I am creating I am doing a Last 12 Weeks Top 20 downtime reasons as you can see the number 1 reason is

    HewSaw|Broken Log @ Scanning Conveyor 9.14% 1

    However I know this is wrong when I look through the data I know that 9.14% is correct but I am not getting the correct reason!

    Any help?

    Many thanks

    Jonny
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: INDEX and MATCH problem

    Please Login or Register  to view this content.
    Enter into cell I5 and drag down.

  3. #3
    Registered User
    Join Date
    10-02-2014
    Location
    Scotland
    MS-Off Ver
    2007
    Posts
    68

    Re: INDEX and MATCH problem

    Thank you for the help

    That formula works brilliant however I need to use the descriptions in the AH Column as there can be the same reason so I have to arranges the reasons by area

    Thanks

    Jonny

  4. #4
    Registered User
    Join Date
    10-02-2014
    Location
    Scotland
    MS-Off Ver
    2007
    Posts
    68

    Re: INDEX and MATCH problem

    I got it now

    Thanks very much for the help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 05-28-2013, 05:08 PM
  2. index/match problem
    By pma85 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 05-23-2013, 04:37 PM
  3. index/match problem
    By Dean81 in forum Excel General
    Replies: 3
    Last Post: 02-24-2012, 07:02 AM
  4. Problem with INDEX, INDIRECT, MATCH, MATCH
    By JO505 in forum Excel General
    Replies: 5
    Last Post: 09-01-2011, 05:51 PM
  5. Problem with IF(INDEX,(Match))
    By Jogier505 in forum Excel General
    Replies: 4
    Last Post: 07-07-2010, 04:02 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