Forum Discussion

JimCarr's avatar
JimCarr
Copper Contributor
Mar 16, 2026
Solved

Selecting a specific year using the FILTER function

I am trying to use the filter function to get all the records from a table for a specific year. I have a table that has a date column  The filter I am trying to use is =FILTER(Venues14,Venues14[Date...
Formulas and Functions
  • JimCarr's avatar
    JimCarr
    Mar 17, 2026

    Thank you I don't know what I was doing wrong but it's fixed now

    Thanks again Jim

Olufemi7's avatar
Olufemi7
Iron Contributor
Mar 17, 2026

Hello JimCarr​, 
=FILTER(Venues14,(Venues14[Date]<>"")*(YEAR(Venues14[Date])=K5),"Is not found")

This formula filters the table to return only rows where the date’s year matches the dropdown in K5 and ignores any blank dates so it works even if some cells are empty

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Mar 17, 2026

If to remove (Venues14[Date]<>"") formula also works assuming we could have blank cells in Date column.