Results 1 to 10 of 10

Dynamic array filter formula

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-29-2009
    Location
    sheffield
    MS-Off Ver
    Excel 2013
    Posts
    210

    Dynamic array filter formula

    On the attached spreadsheet, I am trying to filter the "Database" worksheet by using criteria held in the "Summary" worksheet cell B1. The criteria range is "Database!B:B".

    I want the results to return into the "Summary" worksheet. I have populated the results I'm trying achieve and highlighted them yellow.

    I know I can simply use a column filter but I need to have the results return into a separate worksheet.

    Hopefully all that makes sense.
    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. Create Formula That Changes with Filter (Dynamic Range)
    By AzharNadeem in forum Excel General
    Replies: 8
    Last Post: 01-01-2015, 06:12 PM
  2. Sort and Filter 2D Dynamic Array
    By willia97 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-23-2014, 07:34 AM
  3. Dynamic Row Lookup Array within Array formula
    By OLLY-7 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-17-2014, 04:55 PM
  4. Replies: 6
    Last Post: 05-26-2012, 04:56 AM
  5. VBA for dynamic range in array formula
    By oliver30680 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-01-2010, 07:31 PM
  6. VBA Array formula for dynamic ranges
    By -nada- in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-25-2010, 07:41 AM
  7. [SOLVED] array formula with a dynamic range.
    By Dave in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-26-2006, 01:25 AM

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