Thursday, July 11, 2013

Google Spreadsheet filter rows for a particular year


( by Lift Maint )

I have a list of responses and I would like to be able to take all of the data from 2012 and put it in a new sheet and take the data from 2013 and put it in a new sheet. Also all upcoming years should do the same. Is there a function to be able to do this? I'd guess the "arrayformula" function and "days360" function in combination might be able to accomplish this. 

Thanks for any help you may have!


Now, in your sheet '2012' put the following formula in Cell A1:

=query(arrayformula('Form Responses'!A:T);"select * where year(Col1) = 2012";1)


=filter('Form Responses'!A:T;year('Form Responses'!A:A)=2012)

Use any of the above formula to get the rows for year 2012. And similarly you can get for any other year.

I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.

I also take up private and confidential projects:
If this blog post was helpful to you, and if you think you want to help me too and make my this blog survive then please donate here: 


1 comment:

  1. What if I want to have data in a specific date range. Lets say from December of 2012 to March of 2013?