+ Reply to Thread
Results 1 to 6 of 6

Autofilter with arrays - multiple arrays

  1. #1
    Forum Contributor
    Join Date
    01-22-2022
    Location
    UK
    MS-Off Ver
    365
    Posts
    130

    Autofilter with arrays - multiple arrays

    Is it possible to filter for 3 arrays, each array relating to a separate column.
    The net filter would be the intersection of the 3 criteria.

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    01-22-2022
    Location
    UK
    MS-Off Ver
    365
    Posts
    130

    Re: Autofilter with arrays - multiple arrays

    Thanks, the sample is attached.

    Before:
    Please Login or Register  to view this content.
    After:
    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,525

    Re: Autofilter with arrays - multiple arrays

    Not clear to me.
    What should happen when you change Array_3 to Array(101, 103) instead of 102?

    Anyway the elements of the array used for the criteria in autofilter need to be String, so it should be like
    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    01-22-2022
    Location
    UK
    MS-Off Ver
    365
    Posts
    130

    Re: Autofilter with arrays - multiple arrays

    Thanks for advising.
    For filtering as follows.
    Please Login or Register  to view this content.
    Output should be:
    Please Login or Register  to view this content.
    So the intersection, common for all three arrays.

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,525

    Re: Autofilter with arrays - multiple arrays

    Try change to
    Please Login or Register  to view this content.

  6. #6
    Forum Contributor
    Join Date
    01-22-2022
    Location
    UK
    MS-Off Ver
    365
    Posts
    130

    Re: Autofilter with arrays - multiple arrays

    Thanks jindon, that's a good solution.

+ 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] Querying Large Series of Arrays And Displaying Unique Values in Arrays [Hard Index Match?]
    By larryg003 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-28-2020, 04:52 PM
  2. AutoFilter a column on 3 criteria using Arrays does not work
    By ritesh.sharma25 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-13-2018, 08:46 AM
  3. storing multiple value in a single cell (through arrays or without arrays)?
    By mak51061 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 12-25-2014, 09:27 PM
  4. Declaring multiple multi-dimensional arrays (jagged arrays) - compile error?
    By dfribush in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-20-2013, 05:06 PM
  5. vba compare arrays and remove exact matching arrays
    By jacojvv in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 10-25-2013, 07:30 AM
  6. [SOLVED] New to arrays-where do I find a good beginners guide to multi dimensional arrays
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-04-2013, 07:44 PM
  7. [SOLVED] Arrays - declaration, adding values to arrays and calculation
    By Maxi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-17-2006, 11:15 AM

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