Results 1 to 8 of 8

Index Match in Alphabetical Order with Criteria

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-17-2012
    Location
    CA, USA
    MS-Off Ver
    Microsoft Excel for Microsoft 365
    Posts
    163

    Index Match in Alphabetical Order with Criteria

    I would like to have an index match function provide a unique list of items in alphabetical order and at one criteria for now.

    =INDEX($C$2:$C$52,MATCH(0,COUNTIF($C$2:$C$52,"<"&$C$2:$C$52)-SUM(COUNTIF($C$2:$C$52,"="&G$1:G1))+IF($A$2:$A$52<>"AI",1,0),0))
    But I think what is messing up this is the criteria part that shows +IF($A$2:$A$52<>"AI",1,0). Without this, I get the entire list, sorted into alphabetical order.

    When looking at the attached spreadsheet, I'd like to filter out only if column A includes "AI" and then uniquely sort this in alphabetical order.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] can a index be placed in alphabetical order?
    By AceForSale in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-02-2016, 02:26 PM
  2. index match with multiple returns in alphabetical order
    By mamachrissy1028 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-22-2016, 01:30 PM
  3. Copy tabs names to index sheet in alphabetical order
    By cjharley1450 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-23-2015, 01:00 PM
  4. [SOLVED] Index-Match which does not require alphabetical sort of names
    By FivestarMac in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-07-2015, 12:39 PM
  5. [SOLVED] INDEX names in alphabetical order. Horizontally.
    By JasonNeedsHelp in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-20-2013, 11:43 AM
  6. Densed Rank with 2 critieria with Alphabetical Order as one criteria
    By hamson in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-19-2013, 06:15 AM
  7. Replies: 3
    Last Post: 05-01-2010, 10:23 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1