Results 1 to 14 of 14

Match / Index duplicate value problem

Threaded View

  1. #1
    Registered User
    Join Date
    02-11-2010
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    4

    Match / Index duplicate value problem

    Hi all,

    I have a table with 3 columns, the first being static text "issue types" and the second two dynamic values created from counting instances of each issue type from another sheet.

    I want to create a table of the top 5 issues which updates automatically. I can use the LARGE function to list the top 5 values, and then need to match these to the issue type.

    Where I'm having problems is when there are duplicate numbers for results in the top 5, it will match the first instance 'issue type' for all duplicated entries. Instead I need to put a check in place so that it moves down the table rows to the next instance of the matched number and indexes that issue type instead.

    I know that probably isn't very clear, so please see the attached spreadsheet example for ready made tables and formulas.

    Thanks!
    Attached Files Attached Files
    Last edited by muppetthumper; 07-07-2010 at 07:56 AM.

Thread Information

Users Browsing this Thread

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

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