I have a list of start dates in one tab in Google sheets. I want to pull only the start dates that reflect 2021 into a new tab, as well as pull the corresponding info for that entry from the other columns into the new tab.
Is this possible?
Google-sheets – is there a formula that will allow me to pull data from one google sheet tab to another based on a if contains conditional
google sheetsgoogle-sheets-arrayformula
Related Topic
- Google-sheets – Need to pull rows from one tab to another tab in same spreadsheet that meet certain criteria
- Google-sheets – Copying the latest data from an accumulating list to another sheet
- Google-sheets – Using Query and Importrange to pull Google Form data from one worksheet to another
- Google-sheets – Copying data from one cell in another based on date
- Google-sheets – Dynamic Master sheet that grabs red formatted cells from another sheet
- Google-sheets – Pushing data from one sheet to another based on a condition, without making sheets dependant on one another
- Google-sheets – Google Sheets: Formula to get data from other tab
- Google-sheets – How to pull data from one sheet to another
Best Answer
There are many ways of satisfying your question. This is just one example.
use this query
=query(A1:D6,"select A, B, C, D where year(A)=2021")Sample data
Queried data