Results 1 to 8 of 8

Automatically sort list from index/match formula

Threaded View

Mae Stoll Automatically sort list from... 01-09-2023, 07:25 PM
Phuocam Re: Automatically sort list... 01-09-2023, 08:13 PM
Mae Stoll Re: Automatically sort list... 01-10-2023, 09:10 PM
Mae Stoll Re: Automatically sort list... 01-10-2023, 09:16 PM
sandy666 Re: Automatically sort list... 01-09-2023, 08:35 PM
Mae Stoll Re: Automatically sort list... 01-10-2023, 09:11 PM
wk9128 Re: Automatically sort list... 01-10-2023, 02:46 AM
Phuocam Re: Automatically sort list... 01-11-2023, 08:30 AM
  1. #1
    Registered User
    Join Date
    10-17-2011
    Location
    TX
    MS-Off Ver
    MS Home and Office 2019
    Posts
    10

    Automatically sort list from index/match formula

    I'm using the following array formula to generate a list of unique names from an original list where a name can appear multiple times.

    INDEX($B$3:$B$13,MATCH(0,COUNTIF($D$2:D2,$B$3:$B$13),0))

    Works great, BUT, I need the new list to appear in alphabetical order, right away (in column D), or copied to another column and sorted. It would be simple to do manually, of course, but the original list will change from time to time, so the sorting would need to happen "magically"!

    Thanks so much in advance. I've enclosed a simple example.

    Mae
    Auto sorting question.xlsx
    Last edited by Mae Stoll; 01-09-2023 at 07:30 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 08-17-2019, 01:11 PM
  2. Replies: 5
    Last Post: 10-25-2016, 11:48 AM
  3. [SOLVED] Sort results of INDEX/MATCH array formula remove blanks. . .
    By PeteABC123 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-14-2014, 01:53 PM
  4. Trying to create an if index match formula of some sort
    By Sivalensis in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-03-2014, 11:27 AM
  5. Formula to Index, Match, Rank, and Sort a Dynamic Range of Values
    By AustinLe in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-14-2014, 03:49 AM
  6. Automatically list values using INDEX and MATCH
    By Rob-V-1990 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-21-2014, 10:37 AM
  7. [SOLVED] How to change reference area automatically by dragging Index Match Formula down
    By Nuada in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-20-2013, 01:19 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