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.
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!
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.
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!
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
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 ! :|
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!
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.
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)
Searching this video from so long. Thanks for support!
You're welcome!
Excellent information. Exactly what I needed. Clear and concise. Thanks!
Thank you. Easy to understand. I learnt a lot from your tutorials. Have incorporated to my work.
I was having so much trouble finding a good tutorial for this- this video is great!
I followed your video, but getting a "result too large" error. How can I use IMPORTRANGE column by column with 2 filters?
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.
very very very useful video, Thanks a lot man !!
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!
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.
I needed this. Thanks.
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!
QUERY function wont pull text if columns contain numbers
any alternate solution ?
how to make exception filter, ex show data except graduate?
Thanks for the video Work Perfectly, Looking forward For More videos
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
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 ! :|
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.
Hi...what the furmula is for more than 1 spreadsheet/file
Man, love u so much for this
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!
I believe it's possible!
@@Thekeycuts I tried it but it's not working. Do you think you can teach us that?
@@Thekeycuts The same issue, how would you do that?
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.
Very nice... Thank you very much!...
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!
Thank you this proved very helpful
Result too large error showing during running formulas pls resolve the issue
How sort by date
This is really helpful
Great video❤
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.
You may want to check the spreadsheet ID is correct in your source Google Sheet
I am getting the same thing. My spreadsheet ID is correct. Did you figure it out @Anya Bartlett?
MANY THANKS INDEED BROH!
many thanks
Thanks a Ton
cool
Copy the Google Sheet: Source - docs.google.com/spreadsheets/... Target - thnx you !!!👍
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)
THANK YOU