Results 1 to 19 of 19

Using an array formula to sort alphabetically over multiple columns

Threaded View

  1. #1
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,478

    Using an array formula to sort alphabetically over multiple columns

    I've often found answers to queries here, but not posted until today. I'm looking for some help with an array formula, having started using these only two days ago.

    In the attached example file, I have two tabs: options and sets. The options tab is to be populated from a form. The sets tab is to draw data from the options tab to create teaching sets. I have managed to create an array formula that does this for me, but what I would like it to do is sort my resulting list alphabetically. For reasons that I won't go into, I need the data on the sets tab to remain in three columns: First Name, Surname and Form.

    This is the array formula I am using at the moment:

    {=IF(ISERROR(INDEX(Options!$A$4:I98,SMALL(IF(Options!$H$4:$H$98="French",ROW(Options!$H$4:$H$98)),ROW(1:1))-3,1)),"",INDEX(Options!$A$4:I98,SMALL(IF(Options!$H$4:$H$98="French",ROW(Options!$H$4:$H$98)),ROW(1:1))-3,1))}
    Is anyone able to help me adapt the attached workbook to work in the way I would like, please?

    Thanks in advance.
    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. Pick multiple items from list and sort alphabetically in single cell
    By kawale in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-07-2021, 01:48 PM
  2. Alphabetically auto sort columns
    By higguns in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-22-2013, 12:16 PM
  3. [SOLVED] Sort Array Alphabetically
    By gsurge in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-04-2012, 12:03 PM
  4. Alphabetically Sort Columns Using Top Row
    By ryevick in forum Excel General
    Replies: 3
    Last Post: 12-30-2008, 12:40 PM
  5. UDF to sort array with multiple columns
    By flygis in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-02-2006, 01:10 PM

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