This is so helpful!!! I Used this for a work related query with over 400k rows of data across multiple columns, using multiple conditions. It is was just awesome.
Thank you for sharing such an awesome tutorial. One question #whatif you want to add two cities Mumbai as well as New York. Is it possible? Thanks in advanced
How would I apply a filter where I want to show New York City and Mumbai together in this example? I am looking to filter based on invoice dates of the past week, and not just one day, and I am having trouble figuring this out. I would appreciate any help from you!
I took a two-stage approach to this. I created a separate look-up table with names of all the cities in first column, and in second column a "1" for those cities I want to include, and a "0" for those I want to exclude. I add a column in my data table using a lookup formula, and then use that as the include argument (instead of the city name )in the filter function. This sometimes works fine and in other cases I get #VALUE error, and I have no clue why.
If I defined two criters (City & SKU) then it will filter for the two criterias. What if I want to delete the SKU from the dynamic cell and ask Filter to filter only for the City?
Hello Thank u for ur explaination.. In the 2:46 u showed two cretarias Me when i try the same method with three or four criterias.. it doesnt work.. i tried alot Is there a solution to use this fonction on more than two creteria ? Like filre date and name and function and other criteria Thank you
I have a question! I have two worksheets. one work sheet consists of CustomerName in one column and Income in another column. The second sheet consists of CustomerName in one column and email in another column. The sheet with customername and income has been filtered to provide the customers I am interested in and now I want the sheet with the customername and email to be filtered to only show the customers that I have on the customer and income sheet. How do I do this?! Thank you so much in advance for any help
For filter. There needs to be some condition based on which you want to select. You can enable filter and then add the condition in the Filter By option
Hi, sorry this function is not available in Excel 2010. You can instead use Google Sheets, it's available in there too. And Google Sheets is free to use with any gmail account.
This is not AND combination ! Show example to display only records have Mumbai and speed rope combination.. it should display only when that combination matches ..
super rush, so easy to understand, no bla bla bla, straight to the core!!!, amazing, thank you prof.!
This is so helpful!!! I Used this for a work related query with over 400k rows of data across multiple columns, using multiple conditions. It is was just awesome.
Thank you for sharing such an awesome tutorial. One question #whatif you want to add two cities Mumbai as well as New York. Is it possible? Thanks in advanced
Thank you for the concise and quick explanation!
I think I am going to really like this FILTER function.
This is incredibly helpful and yet such a simple technique. Thank you!
Simple and easy. Works great!
How would I apply a filter where I want to show New York City and Mumbai together in this example? I am looking to filter based on invoice dates of the past week, and not just one day, and I am having trouble figuring this out. I would appreciate any help from you!
I took a two-stage approach to this. I created a separate look-up table with names of all the cities in first column, and in second column a "1" for those cities I want to include, and a "0" for those I want to exclude. I add a column in my data table using a lookup formula, and then use that as the include argument (instead of the city name )in the filter function. This sometimes works fine and in other cases I get #VALUE error, and I have no clue why.
Upto how much times multiple criteria will work.
Thanks a lot. This video really helped me
Great. Now what if I need to see for maybe 2 cities
Hai sir, im using ms office 2007. i want filter function in my office 2007. how to add filter function with my office 2007? plz tell me sir
Thanks very much. This really helps
No one on RUclips have made video with more than 2 filters video.. like New York and Surat to be filter at once in one data
If I defined two criters (City & SKU) then it will filter for the two criterias. What if I want to delete the SKU from the dynamic cell and ask Filter to filter only for the City?
Sir if it filtered by date between?
="good and very easy explanation "
Sir i have a question in case we do 2 criteria filter function, do we still can add if empty option to the formula ?
Yes
THANK YOU SO MUCH SIR!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
This is awesome...
can your add more than 4 criterias ?
Hello
Thank u for ur explaination..
In the 2:46 u showed two cretarias
Me when i try the same method with three or four criterias.. it doesnt work.. i tried alot
Is there a solution to use this fonction on more than two creteria ?
Like filre date and name and function and other criteria
Thank you
thank you sir very useful
I have a question! I have two worksheets. one work sheet consists of CustomerName in one column and Income in another column. The second sheet consists of CustomerName in one column and email in another column. The sheet with customername and income has been filtered to provide the customers I am interested in and now I want the sheet with the customername and email to be filtered to only show the customers that I have on the customer and income sheet. How do I do this?! Thank you so much in advance for any help
You can try using =filter with criteria. But I'm not sure of this, haven't tried it myself yet. Give it a try!
How about or condition?
Please can you help me with the practice file
How to take top 10 in each criteria sir?
If I have 1000 different entries and I want to select 300 entities from them. Can I select those in one action
Yes.
Home - Find and Select - GoTo
In Reference, type A1:A300
Or any such cell reference range that you want to select
@@Excelrush sorry sir, but I want to select multiple entities in filter in one time... Is this possible... If yes then how without using any formula
For filter. There needs to be some condition based on which you want to select. You can enable filter and then add the condition in the Filter By option
@@Excelrush thanks a lot for your kind and quick response... Hatts off sir
How can we use filter and conditional if else and or in same sheet ?
How to filter data by matching a list
Awesome
How to apply same filter in excel 2010
Hi, sorry this function is not available in Excel 2010. You can instead use Google Sheets, it's available in there too. And Google Sheets is free to use with any gmail account.
@@Excelrush can you tell how to apply filter using other methods in 2010, if there is any possibility...
Sample code, for above video example...
You can use the normal Filter option under the DATA tab.
I am using samt mathed in excel 2010 but there showing error that function is not valid.
Plz suggest
Not working😊
The downside of the function is that you cannot edit the result of the filter. You still need to go back to the source to interact with the data.
That’s right, so what’s the best alternative?
hello
This is not AND combination ! Show example to display only records have Mumbai and speed rope combination.. it should display only when that combination matches ..