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 the concise and quick explanation!

This is incredibly helpful and yet such a simple technique. Thank you!

Simple and easy. Works great!

THANK YOU SO MUCH SIR!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Thanks very much. This really helps

Thanks a lot. This video really helped me

thank you sir very useful

="good and very easy explanation "

This is 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

No one on KZread have made video with more than 2 filters video.. like New York and Surat to be filter at once in one data

Great. Now what if I need to see for maybe 2 cities

Awesome

How can we use filter and conditional if else and or in same sheet ?

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!

@peterlewis2255

2 жыл бұрын

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?

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

Sir if it filtered by date between?

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

Please can you help me with the practice file

Sir i have a question in case we do 2 criteria filter function, do we still can add if empty option to the formula ?

@W07043304

2 жыл бұрын

Yes

How about or condition?

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

@Excelrush

Жыл бұрын

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 to filter data by matching a list

How to take top 10 in each criteria sir?

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.

@H-do8tr

4 ай бұрын

That’s right, so what’s the best alternative?

hello

How to apply same filter in excel 2010

@Excelrush

4 жыл бұрын

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.

@tastingtrader7289

4 жыл бұрын

@@Excelrush can you tell how to apply filter using other methods in 2010, if there is any possibility...

@tastingtrader7289

4 жыл бұрын

Sample code, for above video example...

@Excelrush

4 жыл бұрын

You can use the normal Filter option under the DATA tab.

@ashishkoshta137

2 жыл бұрын

I am using samt mathed in excel 2010 but there showing error that function is not valid. Plz suggest

If I have 1000 different entries and I want to select 300 entities from them. Can I select those in one action

@Excelrush

Жыл бұрын

Yes. Home - Find and Select - GoTo In Reference, type A1:A300 Or any such cell reference range that you want to select

@mominrashid3271

Жыл бұрын

@@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

@Excelrush

Жыл бұрын

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

@mominrashid3271

Жыл бұрын

@@Excelrush thanks a lot for your kind and quick response... Hatts off sir

Not working😊

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 ..