+ Reply to Thread
Results 1 to 9 of 9

Filter Formula Based on Year

Hybrid View

  1. #1
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,222

    Re: Filter Formula Based on Year

    Please try

    =FILTER(Table1,IFERROR(XLOOKUP(A12,Table1[#Headers],Table1,YEAR(Table1[Target Return to Service Date - No Delays]))=B12,0))
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    09-25-2018
    Location
    Grimsby, UK
    MS-Off Ver
    365
    Posts
    149

    Re: Filter Formula Based on Year

    Bo-Ry,

    That seems to work, I have changed it to the heading I wanted (Next Out-of-Service Inspection Due Date). I will now try and add it to the end of my working formula.

    Thank you

  3. #3
    Forum Contributor
    Join Date
    09-25-2018
    Location
    Grimsby, UK
    MS-Off Ver
    365
    Posts
    149

    Re: Filter Formula Based on Year

    It worked!!

    Thank you so very much.

    What community!!

+ 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. Cannot filter based on Year
    By KevinF1959 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-20-2020, 02:41 PM
  2. [SOLVED] Need a Formula to sum the total based on year
    By Shan54321 in forum Excel General
    Replies: 10
    Last Post: 03-18-2019, 06:38 PM
  3. Formula to filter out the year based on a list of dates
    By hassanm in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-12-2017, 03:34 AM
  4. Pivot Filter not allowing filter by year, month and date
    By Steve aka Munky in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 02-17-2017, 11:47 AM
  5. [SOLVED] Pivot table - formula/format to filter by month and year
    By HeyInKy in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-17-2014, 01:54 PM
  6. Replies: 1
    Last Post: 07-09-2011, 03:02 AM

Tags for this Thread

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