Also I'm wondering if you have ever appended two import ranges on the same sheet, importing from different worksheets? Do the imported ranges know how to not overwrite each other if the output ranges overlap?
You could include them in an array ={IMPORTRANGE(data), IMPORTRANGE(data)}. You could even use FILTER ON these to remove empty ranges before displaying them and an outer FILTER, SORT or UNIQUE on all the combined array to arrange the data how you like.
How does this differ from using the built-in Filter and Sort features of Google sheets on the Import Range itself? I see that if you want to embed a permanent version of this data it makes sense but then don't they achieve the same thing in the end?
Hi Karl, Filter and Sort features will work on the IMPORTRANGE quite well and would be a good choice if you don't want to make a larger more complete formula around the base FILTER and IMPORTRANGE.
great tips and tutorial! It helps me a lot as a newbie in gsheet, I having a hard time at work and this tutorial helps me a lot, thanks :") quick question, I'm wondering, have you ever using filter+importrange for 2 files using {} (I mean {filter() ; filter ()} , but the two files have a different column number? for example, I want to filter column A:C from file A and column A:G from file B then show it in one table. I knew it won't be allign but I want to make this work. Have any idea?
Hi Bea, A good approach here might be to load the two imported ranges in a hidden sheet tab and then join them together. It will also give you the ability to tweak thinks if you need to in future.
use google app script to merge multiple cells into 1 cell (only in even rows like 2, 4, 6, 8...in a specified range, with the number of merge cells specified by the user), how?
For AND conditions, add an extra condition argument and apply it to the same column. For OR conditions, check out this tutorial: yagisanatode.com/google-sheets-how-to-use-or-inside-a-filter/
Absolutely! In fact, that is the topic of the the 6th video in the Google Sheets IMPORTRANGE series. Check it out: th-cam.com/video/R1XdBB5-wFc/w-d-xo.html
additional tip: to get the column number, go to selected column and type/input this formula in any cell in that column, =COLUMN()
Also I'm wondering if you have ever appended two import ranges on the same sheet, importing from different worksheets? Do the imported ranges know how to not overwrite each other if the output ranges overlap?
You could include them in an array ={IMPORTRANGE(data), IMPORTRANGE(data)}. You could even use FILTER ON these to remove empty ranges before displaying them and an outer FILTER, SORT or UNIQUE on all the combined array to arrange the data how you like.
How does this differ from using the built-in Filter and Sort features of Google sheets on the Import Range itself? I see that if you want to embed a permanent version of this data it makes sense but then don't they achieve the same thing in the end?
Hi Karl, Filter and Sort features will work on the IMPORTRANGE quite well and would be a good choice if you don't want to make a larger more complete formula around the base FILTER and IMPORTRANGE.
Isn't there a way for us to just filter everything including the headers?
great tips and tutorial! It helps me a lot as a newbie in gsheet, I having a hard time at work and this tutorial helps me a lot, thanks :")
quick question, I'm wondering, have you ever using filter+importrange for 2 files using {} (I mean {filter() ; filter ()} , but the two files have a different column number? for example, I want to filter column A:C from file A and column A:G from file B then show it in one table. I knew it won't be allign but I want to make this work. Have any idea?
Hi Bea, A good approach here might be to load the two imported ranges in a hidden sheet tab and then join them together. It will also give you the ability to tweak thinks if you need to in future.
use google app script to merge multiple cells into 1 cell (only in even rows like 2, 4, 6, 8...in a specified range, with the number of merge cells specified by the user), how?
How can I filter by 2 conditions in the same column....for example 2 sales reps
For AND conditions, add an extra condition argument and apply it to the same column. For OR conditions, check out this tutorial: yagisanatode.com/google-sheets-how-to-use-or-inside-a-filter/
Can i replace the name to be found as a cell value? Eg. Steven J russells becomes "C1"?
Absolutely! In fact, that is the topic of the the 6th video in the Google Sheets IMPORTRANGE series. Check it out: th-cam.com/video/R1XdBB5-wFc/w-d-xo.html
plss try version app script importrange with filter
I’m curious about where you work ?
Right here! 😀 yagisanatode.com/about/