+ Reply to Thread
Results 1 to 2 of 2

Filter Sort Issue on Index Match (column with formula Index Aggregate)

  1. #1
    Registered User
    Join Date
    09-27-2018
    Location
    Malaysia
    MS-Off Ver
    MS Office 2010
    Posts
    28

    Filter Sort Issue on Index Match (column with formula Index Aggregate)

    Dear Excel Experts,

    I just recently facing an issue on sorting data with index match formula. The sorting from filter doesn't seem to work accordingly when I tried to sort the data based on alphabetical order and the output remain the same. Below follow the my formula. Is there any way to sort the column with formula intact

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


    The value in C5 is derived from this formula

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


    Thanks
    Kenneth

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    10,947

    Re: Filter Sort Issue on Index Match (column with formula Index Aggregate)

    It may help if you upload a small desensitized sample of you data along with manually typed output that you want based on that data. To upload a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Convert INDEX MATCH AGGREGATE FORMULA to VBA code
    By samuelkmh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-05-2019, 03:28 AM
  2. Dynamic Sort via Index/Match/Aggregate
    By datbigdog in forum Excel General
    Replies: 9
    Last Post: 06-15-2019, 09:02 PM
  3. [SOLVED] Match Multiple Criteria INDEX & Aggregate
    By remyte in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-26-2019, 09:15 AM
  4. [SOLVED] Create List - Index Match or Index Aggregate or other?
    By bambamclint in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 02-10-2019, 01:30 PM
  5. An Aggregate and Index Formula Issue
    By francoiscj1 in forum Excel General
    Replies: 5
    Last Post: 11-19-2018, 09:08 PM
  6. [SOLVED] Index/match sort issue
    By julesmctavish in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-02-2016, 04:43 PM
  7. Index, Match , Auto-Filter, Sort
    By JG101 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-31-2016, 03:40 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1