Filtering IMPORTRANGE data in Google Sheets with FILTER

Подписаться 4,2 тыс.

Просмотров 13 тыс.

50% 1

The starter sheet: docs.google.com/spreadsheets/...
Easter Eggs 🥚 and bonus useful formulas for the curious inside.
The written tutorial: yagisanatode.com/2022/05/11/f...
The IMPORTRANGE series: • Google Sheets - IMPORT...
Learn how to use the FILTER function in Google Sheets to filter source data within an IMPORTRANGE function with 4 key examples:
00:00 Intro
01:01 E.g. 1. FILTER a selected client
06:26 E.g. 2. FILTER a selected client & SORT
08:52 E.g. 3. FILTER a selected sales rep
12:07 E.g. 4. FILTER selected sales rep sales greater than $1,000
More advanced QUERY tips:
- How to get the most frequently appearing words in a column with QUERY - yagisanatode.com/2021/10/19/h...
- Google Sheets: Counting and Filtering Rows where Cells Contain Particular Values. - yagisanatode.com/2019/10/05/g...
If you like the video, check out my website:
yagisanatode.com/
Here is the link to just Google Sheets tutorials:
yagisanatode.com/google-sheets/
Get your copy of the Google Sheet Project Task Manager here: yagisanatode.teachable.com/p/google-sheets-project-tasks-manager
Sign up for my course:
Google Sheets: Learn the Essentials with Three Detailed Projects
yagisanatode.teachable.com/p/...
Grab a Google Sheets Shortcuts Mousepad to help you memorise the Shortcuts.
www.zazzle.com.au/collections...
#GoogleSheets #Spreadsheets #GoogleEdu #administration #GoogleWorkspace

Опубликовано:

30 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 17

@dyobetem 2 года назад

additional tip: to get the column number, go to selected column and type/input this formula in any cell in that column, =COLUMN()

@anhnhatnguyet4628 2 года назад

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?

@karlsouza2597 Год назад

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?

@yagisanatode Год назад

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.

@O_hcomp 12 дней назад

plss try version app script importrange with filter

@karlsouza2597 Год назад

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?

@yagisanatode Год назад

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.

@beabeeeee Год назад

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?

@yagisanatode Год назад

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.

@sofiasilva2344 Год назад

Isn't there a way for us to just filter everything including the headers?

@user-iw4md7hf1c 5 месяцев назад

How can I filter by 2 conditions in the same column....for example 2 sales reps

@yagisanatode 5 месяцев назад

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/

@linz6878 10 месяцев назад

Can i replace the name to be found as a cell value? Eg. Steven J russells becomes "C1"?

@yagisanatode 10 месяцев назад

Absolutely! In fact, that is the topic of the the 6th video in the Google Sheets IMPORTRANGE series. Check it out: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-R1XdBB5-wFc.html