+ Reply to Thread
Results 1 to 3 of 3

Advanced Filter Column

  1. #1
    Forum Contributor
    Join Date
    09-21-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    449

    Advanced Filter Column

    Hello All,

    Please see attached.

    I have a tracker that contains a list of dates in columns M-AD. These are my project milestones. I have added column L. I need a formula in Column L that will allow me to filter to do the following:
    • Show all sites that have a Lease Actual Date but are not yet Acuisition Actual
    • Show All sites that have an Acuisition Actual Date but not yet Work Start Actual Date
    • Show all sites that have a Work Start Actual date but not yet Work Complete Actual date
    • Show all sites that have a Work Actual Date but not yet Job Complete Actual
    • Show all sites that have a Job Complete Actual Date but not yet Transfer Actual
    • Show all sites that have a Transfer Actual Date but not yet an Engineer Actual Date
    • Show al sites Engineer Actual but not yet Deliverable Actual
    • Show all sites that are Deliverable Actual but do not have an Customer Accepted Actual Date

    My goal would be to click on a drop down in column L for example and select something like "Deliverable Actual, Not Customer Accepted" to get a full view of projects that are Deliverable Actual but not yet Customer Accepted.

    **NOTE** our database will either populate a blank, 1/1/1950/ or 1/1/1900 for sites that are not yet Actualized/Actual. In order for there to be an actual date, it would need to be greater than 1.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    09-21-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    449

    Re: Advanced Filter Column

    Desperate bump

  3. #3
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Advanced Filter Column

    Hi
    See if this proposed solution helps.
    I used a new sheet to put the advanced filter and coded that filter to obtain a numerical value that allows you to apply the filter in column L.
    So, use in column L the following formula
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    See the file for clarification
    Attached Files Attached Files

+ 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. losing mind... advanced filter one column works ... the other does not.. why?
    By Thanks4helping in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-24-2015, 04:02 PM
  2. advanced filter - button to re apply advanced filter across multiple sheets
    By motmac87 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-05-2013, 11:16 PM
  3. [SOLVED] Adapt an automated advanced filter code to lock a particular column?
    By Edie0512 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-24-2011, 09:04 AM
  4. Advanced Filter Macro (only returns column headings)
    By Mufasta in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-06-2011, 11:56 AM
  5. Advanced Filter to return Rows w/blank column
    By ChemistB in forum Excel General
    Replies: 3
    Last Post: 04-01-2009, 01:14 PM
  6. [SOLVED] Need to Search Column then Paste Data at end of Row? Advanced Filter?
    By DISMfish@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-12-2006, 07:15 PM
  7. advanced filter a range:Advanced Filter function
    By Il Principe in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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