+ Reply to Thread
Results 1 to 2 of 2

Filter Question

  1. #1
    Registered User
    Join Date
    03-14-2018
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2016
    Posts
    1

    Filter Question

    I am doing pivot reporting on project based financial metrics. I want to limit the results to more than 5 projects.

    There is a column # of projects and we have a lot of one project and two project clients. How do I exclude these from the results?

    Thank you!
    Attached Images Attached Images

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Filter Question

    Hi, welcome to the forum.
    I would suggest a helper column with the # of Projects and set it as a report filter below Year and Active
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

+ 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. Filter question
    By Charles_cz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-07-2012, 08:05 AM
  2. Filter question
    By Paul7 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-11-2008, 01:31 PM
  3. Filter Question
    By Craiglowdon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-24-2007, 03:30 AM
  4. Filter Question
    By GMBunk in forum Excel General
    Replies: 3
    Last Post: 02-16-2007, 06:24 PM
  5. Filter Question
    By bodhisatvaofboogie in forum Excel General
    Replies: 1
    Last Post: 06-20-2006, 11:25 AM
  6. [SOLVED] RE: Filter Question
    By CLR in forum Excel General
    Replies: 1
    Last Post: 04-17-2006, 04:35 PM
  7. [SOLVED] Filter Question
    By WordProc in forum Excel General
    Replies: 1
    Last Post: 04-17-2006, 04:35 PM
  8. Filter question
    By leon22 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-25-2005, 01:44 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