Forum Discussion
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...
Hi. The formula you give is not correct, I'm assuming you just missed the closing bracket after Date so it should have been:
=FILTER(Venues14,Venues14[Date]=K5,"Is not found")
I do not understand why that would return "all the dates instead of just the one". But assuming the [Date] column is a Date and note a Year then the formula should look something more like:
=FILTER(Venues14,YEAR(Venues14[Date])=K5,"Is not found")