+ Reply to Thread
Results 1 to 4 of 4

Excel Filer Function

  1. #1
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    594

    Excel Filer Function

    Hi,
    I've used filter in the follow formula;

    Please Login or Register  to view this content.
    but I would like the array to be dynamic using the match function,

    Please Login or Register  to view this content.
    which spills a true or false, and use this instead of the array,
    I've used INDEX

    Please Login or Register  to view this content.
    with a filter which I've included on second sheet of workbook to show what I'd like to get by using the two filters;

    Please Login or Register  to view this content.

    What am I doing wrong?

    Richard.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Excel Filer Function

    That last formula you've posted works for me. In what way isn't it working for you.

  3. #3
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    594

    Re: Excel Filer Function

    Hmm,
    I've just tried it again, and yes it worked, I've spent nearly an hour and half getting errors, so thanks, don't know what I was doing,

    I'll mark this up.

    Richard.

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Excel Filer Function

    Glad it's sorted & thanks for the feedback.

+ 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] VB Code to filer data by multiple column
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-23-2019, 07:12 AM
  2. SAP file export in excel with images- cant filer
    By remb in forum Excel General
    Replies: 0
    Last Post: 05-03-2017, 11:39 AM
  3. Filer question
    By chriscmartin in forum Excel General
    Replies: 1
    Last Post: 10-07-2014, 11:23 AM
  4. Dynamic pivot filer
    By astolz in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-20-2014, 06:24 PM
  5. Auto filer in excel macro
    By RAJESH MOWERY in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-15-2012, 01:26 PM
  6. [SOLVED] Filer and Copy
    By Curt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-29-2005, 05:00 PM
  7. Filer within Pivot Table
    By Rob in forum Excel General
    Replies: 2
    Last Post: 08-14-2005, 06:05 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