+ Reply to Thread
Results 1 to 6 of 6

Creating a unique alphabetical list (using INDEX and MATCH functions)

  1. 10-28-2013, 06:49 PM #1
    mullahraheil
    mullahraheil is offline
    Registered User
    Join Date
    03-25-2013
    Location
    Srinagar, JK, India
    MS-Off Ver
    Microsoft 365, Office 2007, 2010 & 2016
    Posts
    23

    Unhappy Creating a unique alphabetical list (using INDEX and MATCH functions)

    Hi,

    I am trying to generate a uniquely sorted list from the data on another sheet. I am using an array formula listed below to do so. The raw data I am using is implemented in the Excel Table format (I can't change that as it helps us data management). However, when I run this formula in the data, it returns only the first item in the sorted list. The data I am using here is all text. The formula is -

    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    To test if I was using the formula correctly, I copied the column (TechnicianName) I am using to sort and display to another sheet, and executed the same formula with subtle changes (changed TechnicianName to the range), the same formula is completed flawlessly. Any insight into what I am doing incorrectly?

    With regards,
    mullahraheil.

    P.S. - The data retrieved is also in the Excel Table format, but it didn't work even when I converted it to range.
    Reply With QuoteRegister To Reply
  2. 10-28-2013, 07:04 PM #2
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Creating a unique alphabetical list (using INDEX and MATCH functions)

    well without your workbook its impossible to test
    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula
    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC
    Reply With QuoteRegister To Reply
  3. 10-28-2013, 07:55 PM #3
    mullahraheil
    mullahraheil is offline
    Registered User
    Join Date
    03-25-2013
    Location
    Srinagar, JK, India
    MS-Off Ver
    Microsoft 365, Office 2007, 2010 & 2016
    Posts
    23

    Re: Creating a unique alphabetical list (using INDEX and MATCH functions)

    I have attached a test file.
    Attached Files Attached Files
    Last edited by mullahraheil; 10-28-2013 at 07:58 PM.
    Reply With QuoteRegister To Reply
  4. 10-28-2013, 08:44 PM #4
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Creating a unique alphabetical list (using INDEX and MATCH functions)

    hmm it doesnt seem to work with named range no idea why
    but
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    works
    ah the named range has a blank at the end if you change tecnicianname from ='October-2013'!$C$3:$C$139
    to
    ='October-2013'!$C$3:$C$138 it works
    Last edited by martindwilson; 10-28-2013 at 08:51 PM.
    Reply With QuoteRegister To Reply
  5. 10-28-2013, 10:34 PM #5
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Creating a unique alphabetical list (using INDEX and MATCH functions)

    Quote Originally Posted by martindwilson View Post
    well thats just overkill
    __________
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
  6. 10-29-2013, 07:17 AM #6
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Creating a unique alphabetical list (using INDEX and MATCH functions)

    you could also use this shorter version
    Please Login or Register  to view this content.
    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] Help to create a Index / Match list of unique values.
    By JasonNeedsHelp in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-16-2013, 04:44 PM
  2. Pull Unique Values from a List and Automatically Sort in Alphabetical Order
    By Aimee S. in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-29-2013, 09:43 AM
  3. Index and Match Unique values from list
    By thelegazy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-03-2013, 02:49 AM
  4. Return Unique Values in List Using INDIRECT, MATCH and INDEX?
    By chrisucla12 in forum Excel General
    Replies: 2
    Last Post: 02-02-2013, 05:24 PM
  5. [SOLVED] Excel 2007 : Retrieving unique values from a list by INDEX,MATCH, COUNTIF
    By Mikey7346 in forum Excel General
    Replies: 4
    Last Post: 07-16-2012, 06:22 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