How to import data from another Google Sheet and filter the data with the IMPORTRANGE function

[@KamanaPrakash]

Thank you. Easy to understand. I learnt a lot from your tutorials. Have incorporated to my work.

[@bunty341]

Searching this video from so long. Thanks for support!

[@Thekeycuts]

You're welcome!

[@anyabartlett3547]

I was having so much trouble finding a good tutorial for this- this video is great!

[@walterwhitetailfeather9998]

Excellent information. Exactly what I needed. Clear and concise. Thanks!

[@sirsdsullivan]

I needed this. Thanks.

[@gobindersingh3531]

very very very useful video, Thanks a lot man !!

[@ProfG22]

Man, love u so much for this

[@silvestrecamposano6317]

Very nice... Thank you very much!...

[@mohdaijaz148]

Thanks for the video Work Perfectly, Looking forward For More videos

[@shubhamrawat829]

Excellent tutorial. Can you tell me how can I link this dynamic data pulled from outside my current sheet with the static data that I am entering corresponding to it? So that when there is a new addition to the data there is no mismatch with the static rows.

[@nssdesigns]

Thank you this proved very helpful

[@rezaulkarim3506]

Great video❤

[@bensanchez1532]

Brilliant!! After failing with so many other tutorial I get this to work following your video. Now... How can I do this within the same file landing in a different tab(sheet). I would like Sheet1 to be SourceData and Sheet2 the Imported/Filtered Data

[@hartonogunawan2939]

MANY THANKS INDEED BROH!

[@growwithdata7957]

This is really helpful

[@hoangnguyendinh291]

many thanks

[@TheXervex]

Good evening, First of all thank for this awesome video! I learn how to do the importrange and combined it with a query from another video to add a filter on it. I am working in logistics in a production environment and making a tab to check each production status. For instance a tab with "Nesting" when they are collecting the materials. This will come in the "nesting" tab. But during a weekly follow-up meeting I add comments in a column next to the import range. When the "nesting" than is being put on "finished product" the imported line dissapears (which is my intention), but the comment I wrote myself just stays in the same cell and thus is 'transferred' or 'linked' to the "nesting" row below. When a status changes and dissapears how can I also let the comment dissapear with it? Is this possible? Thanks in advance!

[@Sayuri199x]

Hi, is it possible to use filter for multiple criterion? Like I want to importrange all the data of like 4-7 people (My Criterion) and put them in one sheet.

[@CristinaCastellanos-qz3kk]

What i have been looking for! The only cells that did not import for me was the very top frozen row with the column categories. Do you know why this happens? Thanks!

[@adaapaaja2558]

how to make exception filter, ex show data except graduate?

[@FennySofyanti]

I followed your video, but getting a "result too large" error. How can I use IMPORTRANGE column by column with 2 filters?

[@TheRiyazSaiyed]

QUERY function wont pull text if columns contain numbers any alternate solution ?

[@ozliezz402]

Hi...what the furmula is for more than 1 spreadsheet/file

[@Bnet-gv1dm]

How sort by date

[@MrJordje]

Is it possible to make your filter variables ("Graduate") flexible? F.e. when filter variable = found in a list (with a VLOOKUP)? Great video btw!

[@diptiman2008]

Thanks a Ton

[@dyud6642]

Hi, is it possible to use the filter formula in one column only and filter more than one value? For example, in your video, you filtered "Graduate", is it possible to filter "Graduate" and "Uneducated"? Hope you'll respond to my question. Thanks!

[@Thekeycuts]

I believe it's possible!

[@dyud6642]

@@Thekeycuts I tried it but it's not working. Do you think you can teach us that?

[@neil6407]

@@Thekeycuts The same issue, how would you do that?

[@yunusmuhammednasiridrees5800]

Reference to a cell where you have added a data validation of all possible filter item you need for example, Make a cell (say T1) resultant to a data validation for Graduate, Undergraduate, College etc. replace the cell number in place of "Graduate" to T1 with the Open/closed parenthesis and you only need to tweak your validation to the filter you wish to see.

[@hanishadua474]

I was constantly getting the mismatched error before using INDEX in FILTER. Now when I am done sorting that, there is another error - "No matches are found in the filter evaluation". I have done multiple checks for the source data, my target sheet, column I am trying to pull. All seem to be fine but the function is not working again. Can you help here , please ! :|

[@Thekeycuts]

I would take a look to make sure the data in both source and target sheets don't have extra spaces at the beginning or end of the values.

[@jayprakash-zb3gr]

Result too large error showing during running formulas pls resolve the issue

[@anyabartlett3547]

Help! When I use query function I am getting an error #value! "No_COLUMN: col1" but my source sheet does have a column 1, etc.

[@Thekeycuts]

You may want to check the spreadsheet ID is correct in your source Google Sheet

[@jillferrell4260]

I am getting the same thing. My spreadsheet ID is correct. Did you figure it out @Anya Bartlett?

[@ron4u2k]

cool

[@abnambro1000]

Copy the Google Sheet: Source - docs.google.com/spreadsheets/... Target - thnx you !!!👍

[@tylerdavenport783]

Thank you for this video. I'm trying to use this same method using date range from multiple columns. I feel like I'm close but am getting parenthesis error.. Any ideas what I'm doing wrong? Thanks! =QUERY(IMPORTRANGE("google_sheet_url/","CLUBSMASTER!A:H"),"select Col1,Col2,Col3,Col4,Col5,Col6,Col7,Col8 where Col6 = date '"&TEXT(B1, "yyyy-mm-dd")&"'", 1) OR Col7 = date '"&TEXT(B1, "yyyy-mm-dd")&"'", 1) OR Col8 = date '"&TEXT(B1, "yyyy-mm-dd")&"'", 1)

[@azissyahputracom]

THANK YOU