Results 1 to 6 of 6

Add extra filter to AGGREGATE() report

Threaded View

iepofanof Add extra filter to... 01-31-2022, 09:25 AM
Glenn Kennedy Re: Add extra filter to... 01-31-2022, 09:40 AM
iepofanof Re: Add extra filter to... 01-31-2022, 10:39 AM
JohnTopley Re: Add extra filter to... 01-31-2022, 09:46 AM
XLent Re: Add extra filter to... 01-31-2022, 09:53 AM
iepofanof Re: Add extra filter to... 01-31-2022, 10:37 AM
  1. #1
    Registered User
    Join Date
    09-27-2012
    Location
    Netherlands
    MS-Off Ver
    365
    Posts
    28

    Add extra filter to AGGREGATE() report

    Hi all,

    I have a report that uses the AGGREGATE() function to find specific records.
    Currently it looks for a "YES" in the Orderdisplay sheet/column AO.

    I want to ad a second filter to show only the records with a date corresponding with the selected month.
    See attachment for example file.

    Hope its clear. Thanks in advance!!
    Attached Files Attached Files
    Last edited by iepofanof; 01-31-2022 at 10:37 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Using aggregate with filter
    By Natas20075 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-08-2021, 08:59 AM
  2. How to filter data with Index / Aggregate using multiple criterias.
    By Nicolantonio in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-29-2020, 06:00 AM
  3. Replies: 5
    Last Post: 12-27-2016, 04:24 PM
  4. [SOLVED] Filter / Report Top 10 Values with identifier into new spreadsheet / table / report style
    By steverokh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-04-2013, 05:10 AM
  5. Tying in report filter 2 to report filter 1
    By Aaron. in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-20-2012, 04:44 AM
  6. Filtered Report contains extra rows from a previous set
    By mnsemple83 in forum Excel General
    Replies: 2
    Last Post: 02-10-2012, 05:52 PM
  7. [SOLVED] How to pull extra info into Pivot table report
    By MLK in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-21-2006, 08:25 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