Results 1 to 5 of 5

Year To Date Filter - Multiple Years

Threaded View

  1. #1
    Registered User
    Join Date
    09-18-2012
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    2

    Year To Date Filter - Multiple Years

    Hi,

    Lurked for a while and afraid my first post is asking for help!

    This is something probably stupidly simple but baffling me trying to come up with a solution!

    Basically I need to add a column to my source data so I can use it as a filter on my Pivot Table in a different workbook. - something just as simple as TRUE/FALSE if the date is YTD for all years would be ideal.

    Found a simple solution looking at just the month but need it down to a daily level!

    Have attached an example if that makes it any clearer! nice simple formula would be ideal as sheet is around 600,000 rows long and growing!

    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)

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