Recent videos: IF Functions from Hell in Excel & Google Sheets - Formulas ua-cam.com/video/6cwZoKdZh94/v-deo.html Excel - Create PDF Files from a Spreadsheet - ua-cam.com/video/egoYV8SjGj4/v-deo.html Google Sheets - Share & Work on Spreadsheets ua-cam.com/video/8ttrJiIL1As/v-deo.html Excel Online Link to Other Workbooks - ua-cam.com/video/ivkLvCEJXBk/v-deo.html
Thank you for posting this. I was at a loss as I'm creating a CRM using Google Sheets and this helped me tremendously with this issue. No other video I came across had this exact issue!
It was basic video. I have seen a seprate video of filter function on youtube it was a great video. You are doing great job. Keep doing it is sirji. I appreciate and admire your work
Thanks!!! I was struggling like mad since yesterday night to come up with a solution for this. I am entering data into a sheet that sums up the company's total expenses, but the expenses are made based on multiple projects. First I used filters, but this gets pretty daunting as the data multiplies. I was looking for a way to split the information according to each project in different tabs so I can see the expenses for each without having manually filter, or risk losing data while using copy-paste each time I have an entry. Your explanations are short, easy to follow, and very clear. Thank you!
Good Tutorial and I use filter function a lot. And I learned to add a second filter function to wrap the first filter function to pick the columns I only needed. And on one of my sheets I made a relationship of checkboxes to choose the columns I wanted. I find the filter function to have a lot of uses. Thanks for all the tutorials!!!
Thanks to your previous video about filter functon I was able to make a huge filter thing and my favorite thing is that you can combine different filters putting them all into an array like ={filter(A2:B30,A2:A30="male"),filter(G2:L30,G2:G30>30)} and even sort that range from columns It's insanely useful!
oh? how can you sort? When I try doing sort by converting the header into filter (from Data>Create a filter), it doesn't work :\. Can you suggest where I should look at?
Thanks for this videos it is a great help, but why are some of the columns being left out when I do it. Is there a certain amount of columns that it can take?
Thank you so much! This was so helpful to help me sort commission rule data and customize it to the type of sale my employees did! I am forever grateful!
Great video; I have a similar need and having issues. I want to compare names from from sheet and where the names matches, add the data for the phone number in a cell . Any suggestion on what option I should use?
This is a great video, thank you! I am wondering, can you use this filter function to pull information from multiple worksheets? So if you had another sheet with customers in, could you pull based on criteria from more than one sheet (with the same criteria) into the data pull sheet?
i had same query, did you find any solution for the same. Also what i did to solve my problem temporarily is that i placed the first pull out from column A to Column F representing sheet 1 and then the second pull out from column H to column M representing sheet 2, deliberately left column G blank for spacing.
Nice video. About the drop down: After selecting filtering options using the dropdown menu, is there any way to revert back to "show all"?. I tried to figure out but I could not find the way. Cheers
Yes. It's a little bit complicated, you need to do an if statement and if it's "show all" you need to return the whole data or create an array of TRUE values. The easy thing would be something like =IF(A1="Show All", fulldatarange, FILTER(blah blah))
Hi! Thanks for this video. Just I have one query. If I have to pull Data from Another Sheet based on a Criteria and I want that this new created sheet automatically get updated based on same criteria if worked on 1st sheet. How to do that. I do hope I will get answer. Thanks again.
Thank you for this video. I have an additional question. If I make another entry in the "customer" sheet, how can this entry be updated in the "data pool" sheet? Please help. Thank you
Sir I need your help little bit I have created a mail template using vba and shared my all staff and created UI FOR SENDING THE MAIL BY ANY ONE SO ISSUE IS LAST SIGNATURE IMPRESSION IF I SEND THE MAIL THEN OK I SET THE SIGNATURE BUT IF OTHER STAFF CLICK ON THAT UI BUTTON THEN MAIL WILL BE SEND BUT BY MY SIGNATURE SO HOW IT CAN IMPROVE
Can data be pulled not from only one sheet to another, but from many as well. Let us say I have sheets from January to December, and wish to pull certain data from each one of them to a new one, is it feasible using this one formula you just showed ??
I have a sheet that brings whole rows over from another sheet depending on a status of a dropdown like your male, or female example. can I change the status of that dropdown in the new sheet? ie change male to female in the new sheet and it disappears while male is selected but is on the list when female is selected? At the moment the first entry has the formula in it so I can't change it.
Great video, thanks for the upload! Further extending this scenario, is there a way to automate this process so that when a new entry is created in the masterfile, it will automatically pull the data and display it in the relevant worksheet? [e.g if a new female customer is added to the database, google sheets will automatically copy their data into the worksheet for female customers?]
Hello! Does the filter function work where it is filtering text that is based on a formula? For example, I am looking to pick up all cells that are scored higher than 12, but the cells within the array are based on returns from an xlookup formula across 6 other spreadsheets. I hope this makes sense!
Thanks 🙏👍 for video,I have used index,vlookup and many other methods,but thanks God,filter is easiest to use,thank u so much,I took me almost 10 days to lookup this video and found what I'm searching for,thanks once again.
Thank you for this. If I am using excel to keep track of my "open" work tasks and I have a tab for each segment of work and within each tab I have tasks that are "OPEN". How do I get one excel sheet to display the Open from several excel sheets?
I was wondering if this would work if I had a timestamp column and it’s in this format “4/1/23 14:00” could I put my criteria at 4/1/23 to pull all data regardless of the the time .. or would I have to separate it ? Because my software exports the cvs file in this format..
If the file size gets too large with the number of rows in my data being pulled with Filter function, how do i control that esp when I have to house my two connected files on Sharepoint?
Need your help, don't know if you can. We have a main tab with data of leads. Theres a column:L - with URLS, and Column:M - with Empty space for Emails to go. The 2nd tab is where our VA found SOME of the emails for the URLS in the main tab. So right now in the 2nd Tab it looks like this: Column:L - Same URLs from Main tab, and Column:M - Emails found for some of the URLS. Question: How do we get the emails that were found for SOME of the URLS to move over to the main tab Column:M but match the CORRECT URLs even though the URL's are all mixed up on the main tab Column:L??? Thank you!
Could you help me regarding this doubt I have 2 Excel files First file having 10 customers data (unique ID no., name Age, salary). Second file has 15 customers data (unique ID no., name Age, salary). But both files have 7 common customers. I want that, if my changes 1st file data (salary data) of some customer .The changes should be automatically updated in 2nd file for that customer. Example: If I change the salary of a person (in 1st file), then Excel should identify the unique ID no. (In 1st file) And after that Excel will automatically search this unique ID no. In 2nd file and after searching, Excel will update salary for that unique ID no.
Great video! Happy to find the Filter function. When applying the IF statement to my filter, I receive an error “you’ve entreated too many arguments for this function.” Any assistance would be great to eliminate the zeros. Thanks!
I have a compex excel workbook to log all my vegetables. I want to pull certain selected data from the main tab called 'VegetableList' into another two tabs called 'sowinglist' and 'orderlist'. I have identified the vegatable I want in the second tab by an 's' for sowing and 'o' for ordering in a column in the main tab. i have meticulously followed the formula as instructed substituting customers for vegetablelist and identifying the correct range of cells, etc. but it keeps saying furmula invalid. HELP!
Hi mate. You’re videos are great. Easy to understand and very comprehensive. You just earned a subscriber. 🎉 I am looking on how to map specific columns in two separate sheets. So if you have any video on this please share a link otherwise would appreciate if you create a video on this topic. Thanks once again and keep it up. Ta
Great content. I have a question. While using the Query function, I have added data from different Google sheets through Importance and combined into one. The sheet is not moving data where special characters are used like / +. Please advise how can I include that data too.
How would this work with checkboxes? The data pulled only presents true or false on another sheet rather than the actual checkboxes. Any advice would be great!
IF select from drop down a text "abc" then what ever I write on the same sheet should also write same in real time on the other sheet , and if I select "def" text from drop down then it should be written on the DEF sheet please guide, Thanks in advance
can we also change the column while it get filter from the original data? i.e: original data has some figure on column "H" but while getting the data I needed that "h" data to be shown in column "g" ......is it possible ? please help
Great video! My only issue is not being able to sort. Data is pulled in properly, but I am not able to edit any cells without losing the whole table. Sorting shifts some data down a few rows. help!
Fantastic video that answered a question I had searched all day for. One additional question regarding my "data pull" tab: I want to add additional columns on that tab and provide more data and keep that data tied to the row that it's in. Say i added something in in the data pull tab in cell L6, information for Donna Garcia. Then on the native "customers" tab I change Monica from Male to female, or delete her entry. When I do that everything shifts up and the data i entered for Donna is now in the same row as Crystal. Is there a way to tie that info to Donna?
What if I only want one column from the data range? I'm trying to create a mailing list so I only care about the "e-mails" column, instead bringing all columns from the source data, how could I do that?
Hi, great video!! I just wanted to ask you... I have a table with multiple product codes with there description, prices, etc. I want that data to be pulled in another sheet when i write a code that matches with one in the table... _Is there any way to do that? Thanks for all you videos I'm trying to learn a little more about spreadsheets codes to make my work easier.
Nice! Thanks for the video. This gives me hope what I am trying to do is possible. I have a list of tasks with target dates. I want to pull the information to another sheet if the target date falls between the current work week. Is that possible?
It's possible. You'll need to use some date functions to figure out the start and end date of your current work week and then use those dates to filter the data using filter function.
is there a code you could use on Google sheets that could make the data you pull from the customers sheet modifyable and also reflect the changes on the customer tab and data pull tab?
Very nice! I didn't know Excel has a filter formula now! Anyway, there's a way to use the filter for parts of words (where H2 is the cell where you type what it needs to filter on): =FILTER(A:B,NOT(ISERROR(SEARCH(H2,A:A)))) Also, there is a way to not have the filter statements be "And" statements, so you can filter on two separate things (where H2 and H3 have search words to filter on): =FILTER(A:B,(NOT(ISERROR(SEARCH(H2,A:A)))) + (NOT(ISERROR(SEARCH(H3,A:A)))))
Can you help me include in the formula to pull data if the cell contains that specific word. For example, one cell contains apples, bananas. Another apples. Another cell, apples, bananas, orange. I want to be able to pull all of these rows because they all contain apples. Thank you !
I am not working with data but templates I have created for roles within the company I work for. Each template is based on their role they have. I have several templates for each role in the company. Depending on what role is chosen I want to display this named range of cells on the same worksheet as the drop down list. I am hoping someone can point me in the correct direction.
Recent videos:
IF Functions from Hell in Excel & Google Sheets - Formulas ua-cam.com/video/6cwZoKdZh94/v-deo.html
Excel - Create PDF Files from a Spreadsheet - ua-cam.com/video/egoYV8SjGj4/v-deo.html
Google Sheets - Share & Work on Spreadsheets ua-cam.com/video/8ttrJiIL1As/v-deo.html
Excel Online Link to Other Workbooks - ua-cam.com/video/ivkLvCEJXBk/v-deo.html
You just saved me at leasr 5 hours of manual work. Thank you so much!!
Quick and easy to follow explanation! I was searching and kept coming up with other solutions that didn't meet my needs. Yours did thank you!
Thank you for posting this. I was at a loss as I'm creating a CRM using Google Sheets and this helped me tremendously with this issue. No other video I came across had this exact issue!
Ohhhh my god thank you so much been looking this up for the whole morning. My sheets are gonna be so convenient to use now. Thank you!
It was basic video. I have seen a seprate video of filter function on youtube it was a great video. You are doing great job. Keep doing it is sirji.
I appreciate and admire your work
Thanks!!! I was struggling like mad since yesterday night to come up with a solution for this. I am entering data into a sheet that sums up the company's total expenses, but the expenses are made based on multiple projects. First I used filters, but this gets pretty daunting as the data multiplies. I was looking for a way to split the information according to each project in different tabs so I can see the expenses for each without having manually filter, or risk losing data while using copy-paste each time I have an entry. Your explanations are short, easy to follow, and very clear. Thank you!
Hey.. how to do this from two different google sheets? What you showed is within one google sheet..
Good Tutorial and I use filter function a lot. And I learned to add a second filter function to wrap the first filter function to pick the columns I only needed. And on one of my sheets I made a relationship of checkboxes to choose the columns I wanted. I find the filter function to have a lot of uses. Thanks for all the tutorials!!!
That's what I was looking for when I came across this tutorial.
Thanks to your previous video about filter functon I was able to make a huge filter thing and my favorite thing is that you can combine different filters putting them all into an array like ={filter(A2:B30,A2:A30="male"),filter(G2:L30,G2:G30>30)} and even sort that range from columns It's insanely useful!
You could even use the Query function for that, but yes, the filter function is insanely powerful!
oh? how can you sort? When I try doing sort by converting the header into filter (from Data>Create a filter), it doesn't work :\. Can you suggest where I should look at?
@@abdullamasud4278 I meant with the sort() formula
(Using Google Sheets)
@@Maestr055 I really don't like the query formula, maybe I don't fully understand it lol
Tho I know SQL this one is weird
Thanks for this videos it is a great help, but why are some of the columns being left out when I do it. Is there a certain amount of columns that it can take?
Thanks a lot. On the drop down if you wanted to pull down more than 1 field, say 2 fields. Say male and female, is there a way to do that? Thanks
Thank you very much. You helped me to succeed with my project in about 1 minute of your video. Awesome.
Thank you so much! This was so helpful to help me sort commission rule data and customize it to the type of sale my employees did! I am forever grateful!
Perfect - I've been searching for a formula for the last 3 hours!!! and this works!!
Great video; I have a similar need and having issues. I want to compare names from from sheet and where the names matches, add the data for the phone number in a cell . Any suggestion on what option I should use?
This is a great video, thank you! I am wondering, can you use this filter function to pull information from multiple worksheets? So if you had another sheet with customers in, could you pull based on criteria from more than one sheet (with the same criteria) into the data pull sheet?
i had same query, did you find any solution for the same. Also what i did to solve my problem temporarily is that i placed the first pull out from column A to Column F representing sheet 1 and then the second pull out from column H to column M representing sheet 2, deliberately left column G blank for spacing.
Also looking for this.
THANK YOU YOU SAVED MY JOB
Great!
If you added a female customer in your master list will it update the items in the data pull tab?
Would filter formula work if I wanna pull data from multiple tabs?
You have no idea how much you just helped me! Thanks for the video.
Glad to hear!
Nice video. About the drop down: After selecting filtering options using the dropdown menu, is there any way to revert back to "show all"?. I tried to figure out but I could not find the way.
Cheers
Yes. It's a little bit complicated, you need to do an if statement and if it's "show all" you need to return the whole data or create an array of TRUE values.
The easy thing would be something like
=IF(A1="Show All", fulldatarange, FILTER(blah blah))
@@ExcelGoogleSheets I'll try that. Much appreciated 👍🏻
Will this function work if new data is entered and will it move it automatically?
Is there a way that the resulting output will be only specific columns that I want from the array?
Hi! Thanks for this video. Just I have one query. If I have to pull Data from Another Sheet based on a Criteria and I want that this new created sheet automatically get updated based on same criteria if worked on 1st sheet. How to do that. I do hope I will get answer. Thanks again.
How can i replace or fill blank cells with zero in pivot table? Thank you for your answer
Can you filter it it pull the data based on multiple responses from the same column ie: by state: KS, CA & TX.
Is there a way to do this with a living document? Meaning that the filters will still work etc as you add rows and more info into the sheet?
Is there a way to have a "Show All" selection in the filter list (Excel)? In other words be able to use the drop down to show male or female or all.
Thank you for this video.
I have an additional question.
If I make another entry in the "customer" sheet, how can this entry be updated in the
"data pool" sheet?
Please help. Thank you
Hello just a question. How do you do it if you want to filter a column of numbers instead of a string
Sir I need your help little bit
I have created a mail template using vba and shared my all staff and created UI FOR SENDING THE MAIL BY ANY ONE
SO ISSUE IS LAST SIGNATURE IMPRESSION
IF I SEND THE MAIL THEN OK I SET THE SIGNATURE BUT IF OTHER STAFF CLICK ON THAT UI BUTTON THEN MAIL WILL BE SEND BUT BY MY SIGNATURE
SO HOW IT CAN IMPROVE
Can data be pulled not from only one sheet to another, but from many as well. Let us say I have sheets from January to December, and wish to pull certain data from each one of them to a new one, is it feasible using this one formula you just showed ??
Worked! However, if you try to edit anything in the new list that was pulled, the whole data will erase and shows up as "REF" error
I have a sheet that brings whole rows over from another sheet depending on a status of a dropdown like your male, or female example. can I change the status of that dropdown in the new sheet? ie change male to female in the new sheet and it disappears while male is selected but is on the list when female is selected? At the moment the first entry has the formula in it so I can't change it.
This was cool, is there a way to pull particular filter to different sheet, not a different tab? Some way to merge import range with filters?
I don't see why not.
@@ExcelGoogleSheets how?
Just put importrange function instead of ranges you select.
Great video, thanks for the upload!
Further extending this scenario, is there a way to automate this process so that when a new entry is created in the masterfile, it will automatically pull the data and display it in the relevant worksheet? [e.g if a new female customer is added to the database, google sheets will automatically copy their data into the worksheet for female customers?]
This should do in Google Sheets ua-cam.com/video/QTySwuhpHG0/v-deo.html
Hello! Does the filter function work where it is filtering text that is based on a formula? For example, I am looking to pick up all cells that are scored higher than 12, but the cells within the array are based on returns from an xlookup formula across 6 other spreadsheets. I hope this makes sense!
Thank you! This was the best and helped me so much. I was able to link data sheets for easy editing and viewing for my staff.
Be careful with editing part. Data should not be edited in the results sheet.
Can this same process work if I have multiple different files, not just sheets?
Thanks 🙏👍 for video,I have used index,vlookup and many other methods,but thanks God,filter is easiest to use,thank u so much,I took me almost 10 days to lookup this video and found what I'm searching for,thanks once again.
Great to hear! Welcome to the channel👍
How would one sort the data after using the Filter function? ie, put it in alphabetic order?
Is it possible to MOVE data from another sheet based on criteria?
Hi, what if the criteria is different numbers (UID) - what do you type?
This was very simple and useful. Thank you!
Love it. Another feature I just learned existed. This works for the project I have in mind. Thank you so much!!!
Thank you for this. If I am using excel to keep track of my "open" work tasks and I have a tab for each segment of work and within each tab I have tasks that are "OPEN". How do I get one excel sheet to display the Open from several excel sheets?
I was wondering if this would work if I had a timestamp column and it’s in this format “4/1/23 14:00” could I put my criteria at 4/1/23 to pull all data regardless of the the time .. or would I have to separate it ? Because my software exports the cvs file in this format..
If the file size gets too large with the number of rows in my data being pulled with Filter function, how do i control that esp when I have to house my two connected files on Sharepoint?
Thanks so much for your videos. You explain complex matters really easily, and I'm finding the info incredibly helpful!
great explanation, I only have one little question; could you sub filter this by specific Zip code numbers with a drop down list?
sure
if I do have ms-office 2013 then what should i do filter out the same by like by employee name or Dept.. what type of formula i should apply..
I want to pull the data if the column has any value in it and not blank. Will the same formula work?
you're a hero! thank you for this video
Is it possible to do this with the criteria being a date range? for example: return all data from 9/23/23 - 10/5/23.
Need your help, don't know if you can. We have a main tab with data of leads. Theres a column:L - with URLS, and Column:M - with Empty space for Emails to go. The 2nd tab is where our VA found SOME of the emails for the URLS in the main tab. So right now in the 2nd Tab it looks like this: Column:L - Same URLs from Main tab, and Column:M - Emails found for some of the URLS. Question: How do we get the emails that were found for SOME of the URLS to move over to the main tab Column:M but match the CORRECT URLs even though the URL's are all mixed up on the main tab Column:L??? Thank you!
How do I use this formula but instead of male or female, I want to pull line items from a spread sheet if the value is equal to or greater than 1?
Great video......as you create always.
Could you help me regarding this doubt
I have 2 Excel files
First file having 10 customers data (unique ID no., name Age, salary).
Second file has 15 customers data (unique ID no., name Age, salary).
But both files have 7 common customers.
I want that, if my changes 1st file data (salary data) of some customer .The changes should be automatically updated in 2nd file for that customer.
Example:
If I change the salary of a person (in 1st file), then Excel should identify the unique ID no. (In 1st file) And after that Excel will automatically search this unique ID no. In 2nd file and after searching, Excel will update salary for that unique ID no.
Is there a way to input sheet name from a dropdown list of sheet names?
Great video! Happy to find the Filter function. When applying the IF statement to my filter, I receive an error “you’ve entreated too many arguments for this function.” Any assistance would be great to eliminate the zeros. Thanks!
Terima kasih .. memang tebaik bossku!
omg you just saved me so much time!thank u
How do you ensure that you pull certain headings from previous sheet?
How do you decide when you use filter fonction instead of a query ?
I use filter when I need to filter. When I need to group by, sum and stuff like that, then I'll use query.
How about using the filter feature but we only want some of the times to be copied how would we do that?
In excel, do the formulas in the original spreadsheet copy over and does it stay as a table? Btw. This is a great solution. So easy.
I have a compex excel workbook to log all my vegetables. I want to pull certain selected data from the main tab called 'VegetableList' into another two tabs called 'sowinglist' and 'orderlist'. I have identified the vegatable I want in the second tab by an 's' for sowing and 'o' for ordering in a column in the main tab. i have meticulously followed the formula as instructed substituting customers for vegetablelist and identifying the correct range of cells, etc. but it keeps saying furmula invalid. HELP!
Hi mate. You’re videos are great. Easy to understand and very comprehensive. You just earned a subscriber. 🎉
I am looking on how to map specific columns in two separate sheets. So if you have any video on this please share a link otherwise would appreciate if you create a video on this topic. Thanks once again and keep it up. Ta
Great content. I have a question. While using the Query function, I have added data from different Google sheets through Importance and combined into one. The sheet is not moving data where special characters are used like / +. Please advise how can I include that data too.
Use filter function instead of query.
There is a channel, excel for freelancers teaching a school management system, can you show us something similar using google sheets?
This filter formula function not available while I type the filter ....How
How do u do t his through all worksheets? Say I have like 50 sheets and I want to filter the data from them all into 1 sheet?
ua-cam.com/users/LearnGoogleSpreadsheetssearch?query=combine%20multiple%20sheets%20master
How would this work with checkboxes? The data pulled only presents true or false on another sheet rather than the actual checkboxes. Any advice would be great!
You would need to add checkboxes to the output column, otherwise checkbox is just TRUE/FALSE
@@ExcelGoogleSheets Thanks!
IF select from drop down a text "abc" then what ever I write on the same sheet should also write same in real time on the other sheet , and if I select "def" text from drop down then it should be written on the DEF sheet please guide, Thanks in advance
Glad to see this tutorial. It helps me a lot in reporting. Is there a way to have multiple filters, e.g. I want to filter two items from same column?
Yes. Watch FILTER function video on the channel for more information.
can we also change the column while it get filter from the original data? i.e: original data has some figure on column "H" but while getting the data I needed that "h" data to be shown in column "g" ......is it possible ? please help
Is source code available on Patreon or elsewhere?
Do you help people create custom things?
Great video! My only issue is not being able to sort. Data is pulled in properly, but I am not able to edit any cells without losing the whole table. Sorting shifts some data down a few rows. help!
Fantastic video that answered a question I had searched all day for. One additional question regarding my "data pull" tab: I want to add additional columns on that tab and provide more data and keep that data tied to the row that it's in. Say i added something in in the data pull tab in cell L6, information for Donna Garcia. Then on the native "customers" tab I change Monica from Male to female, or delete her entry. When I do that everything shifts up and the data i entered for Donna is now in the same row as Crystal. Is there a way to tie that info to Donna?
Did you ever get an answer to this?
Exactly what I needed!!!
Great!
How to import data automatically from another sheet based on time..
Like daily attendance details
What if I only want one column from the data range? I'm trying to create a mailing list so I only care about the "e-mails" column, instead bringing all columns from the source data, how could I do that?
Hi, great video!! I just wanted to ask you... I have a table with multiple product codes with there description, prices, etc. I want that data to be pulled in another sheet when i write a code that matches with one in the table... _Is there any way to do that? Thanks for all you videos I'm trying to learn a little more about spreadsheets codes to make my work easier.
ua-cam.com/video/XBfBkDYdmjk/v-deo.html
how do pull percentage data? is it still the same process?
You have added much value. Thank you!
Could the filter function be used in a drop down list of validation data?
Not directly in the validation setup. You can use it in the spreadsheet and then point to the results as a range.
Nice! Thanks for the video. This gives me hope what I am trying to do is possible. I have a list of tasks with target dates. I want to pull the information to another sheet if the target date falls between the current work week. Is that possible?
It's possible. You'll need to use some date functions to figure out the start and end date of your current work week and then use those dates to filter the data using filter function.
Thank u so much, but how if criteria has only 'text contains' ? Any tips guys ? Thanks in advance
Watch this video ua-cam.com/video/JQSlbQeEz1k/v-deo.html
Hi there, thanks for this super helpful video. Is it possible to do a filter in Google Sheets on a partial text criteria?
what is the subtitle function for the filter function. I'm using excel 2019 version
There is no alternative function. You can use Power Query ua-cam.com/video/vALA_KC9DtQ/v-deo.html
is there a code you could use on Google sheets that could make the data you pull from the customers sheet modifyable and also reflect the changes on the customer tab and data pull tab?
Is there a way to 'link to the source data' on whatever 'main data set' the filter was taken from?
I'm facing a problem while sorting the filtered data. It says, 'You can't change part of an array". Excel thinks the data is an array. What can I do?
Very nice! I didn't know Excel has a filter formula now! Anyway, there's a way to use the filter for parts of words (where H2 is the cell where you type what it needs to filter on):
=FILTER(A:B,NOT(ISERROR(SEARCH(H2,A:A))))
Also, there is a way to not have the filter statements be "And" statements, so you can filter on two separate things (where H2 and H3 have search words to filter on):
=FILTER(A:B,(NOT(ISERROR(SEARCH(H2,A:A)))) + (NOT(ISERROR(SEARCH(H3,A:A)))))
thank you bro, help a lot!
You are a LIFESAVER thank you!
Can you help me include in the formula to pull data if the cell contains that specific word. For example, one cell contains apples, bananas. Another apples. Another cell, apples, bananas, orange. I want to be able to pull all of these rows because they all contain apples. Thank you !
I am not working with data but templates I have created for roles within the company I work for. Each template is based on their role they have. I have several templates for each role in the company. Depending on what role is chosen I want to display this named range of cells on the same worksheet as the drop down list. I am hoping someone can point me in the correct direction.
Amazing. What if we have a date column in data and we want to filter the data by changing date in reference cells?
Use a cell like I did with numbers.
Great content bro