Sheet1 will have data with different past dates
Sheet2 - I want to import data from the 1st sheet and find the closest date to today's date.
https://docs.google.com/spreadsheets/d/1Kr5NRb4TmNhr8hQb2DXt6pdK4UC3H1IUFGjvQtucWQw/edit?usp=sharing
2
-
pls share a copy of your sheet– user0Jun 10, 2019 at 16:13
-
Please add a brief description of your search/research efforts as is suggested on How to Ask.– Rubén - People First ♦Jun 10, 2019 at 16:47
Add a comment
|
1 Answer
When you want to get data in the same spreadsheet you do not need IMPORTRANGE.
Let's say Sheet1 looks like this:
Then in Sheet2 you need to do this:
=FILTER(Sheet1!A:Z, Sheet1!A:A=MAX(Sheet1!A:A), Sheet1!A:A<=TODAY())
