+ Reply to Thread
Results 1 to 2 of 2

Alternative function ideas instead of filter?

  1. #1
    Registered User
    Join Date
    01-27-2021
    Location
    atlanta
    MS-Off Ver
    365 (Enterprise)
    Posts
    24

    Alternative function ideas instead of filter?

    Hi, I'm currently helping a team quickly gather data based on a value in another column, and I've found the filter function to the best way to dynamically list the array. The full formula is:

    =INDEX(FILTER(Table1[#Data],Table1[Group]='Source Data '!L2),SEQUENCE(ROWS(FILTER(Table1[#Data],Table1[Group]='Source Data '!L2))),{27,2,3,20,22,13})

    Where I'm using Filter to first list out the rows and Index to list out the columns I need. But I'm using MS 365 for Enterprise while my colleague uses MS 365 ProPlus and she gets the xlfn error in the formula bar. Is there a workaround that can give me the same results for older Excel versions? Especially one that will list the data as an array? Thanks!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-27-2021
    Location
    atlanta
    MS-Off Ver
    365 (Enterprise)
    Posts
    24

    Re: Alternative function ideas instead of filter?

    I'm also thinking of an alternative with using a pivot table from the data and having the macros paste into the different tables... is it possible for the macros to also refresh the tables?

+ 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. [SOLVED] Alternative to Filter in older excel?
    By mashphat in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-04-2021, 05:59 AM
  2. Replies: 19
    Last Post: 02-10-2016, 05:49 AM
  3. [SOLVED] alternative to lookup function and filter
    By jpk005 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-01-2014, 03:59 AM
  4. PowerPivot/Excel Alternative ideas?
    By simbalyon303 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 6
    Last Post: 05-07-2013, 07:20 AM
  5. Looking for Alternative Ideas for my Situation... dynamically filtering comboboxes?
    By DamnRock in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-23-2013, 04:04 AM
  6. Need ideas on how to best implement a function in ADD-in
    By matelot09 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-08-2012, 01:45 PM
  7. Alternative to Copy and Filter?
    By glowworm in forum Excel General
    Replies: 0
    Last Post: 10-06-2010, 12:34 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