Excel FILTER FUNCTION across multiple sheets 

Thank you! You made it easy to understand

So it is pulling data across multiple sheets, great :) ... now give me the FILTER FUNCTION across multiple sheets please :D Filter data on one list and have them filtred on other list as well :))

Thank you for this video, it was exactly what I needed! Your video was straight to the point and no waffle. Thank you very much!!!

Absolutely brilliant!!!!! exactly what i was looking for - THANK YOU!!!!!

Thank you! I've been looking for this. Amazing video and great presentation.

Worked like a charm, thank you!

Fantastic practical real world example, thank you!

Finally it worked & reduced a lot of pressure at work thank you so much!!

You. Saved. My. Life. Thank you so much❤

Great video, thanks!

Thank you for this. Although it still took me a couple of attempts to get where I wanted to be, this video certainly helped me find my way there.

Thanks for the wonderful video ...

thank you so much!! it really help me to combine my sheet!

Hi Man, Thank you very much!

Thank you for this video! I have successfully used your formula to get the Selling Price per Unit and the Sales Percentage into one sheet. However, is there a way to get Percentage Mark in the filter. The source is already with the % mark, but it does not come through in the filter

THANK YOU VERY MUCH

Thank you very much

Hi, I have tried this but it seems Vstack is not in 2021 version of excel. Is there a work around by any chance? TIA

Thank you very much! How can I apply for the multiple workbooks?

This is what I've been looking for, but for some reason I've been having trouble to combine it with filter function, I tried as well to separate the 2 functions unfortunately it didn't work. Any suggestions?

Thank you

I would like to suggest adding dynamic search function using VBA, its pretty straightforward but gives you results as you type.

I wonder if there any alternative way to do this horizontally, thank you!

Very helpful, thanks. I have mirrored the above with my dataset and can get the FILTER function to work when the column/range I am searching within contains text or straight number however when the data in the column is a number which is the outcome of a formula, it does not return any values. For example, imagine you had an additional column for 'Date of Birth' and rather the data in the 'Age' column being input as a number, it was the result of a calculation/formula (say today's date minus date of birth). When you then try to filter the 'Age' column for people aged under 40 (i.e.

how do i show the comments from the original cell in the cell of the filtered results?

I try to use vstack on google sheet but it doesn't work by using shift across many tab. I need to pull data one by one and it become a long formula. Do you have any suggestions for me?

This function is not working in my excel sheet

I have columns "completed date" and "transition to" but it is returning "0" as default even though I formatted it I would not change. these values are taken into my master data tab on which all the data are there.

This tutorial was, quite simply, *excellent*. Thank you so much ! =]

Thank you very much for this video. Please correct me if I'm wrong but it appears there is a condition attached to the formula which is not obvious; the total number of rows in all the sheets cannot exceed the Excel's row limit. I have data on four sheets with a total combined row number of 1,800,000 rows. The formula only works when the total combined row number is less than 1,048,576.

Thank you, this is very useful! Is it possible to add one more last name to filter so it would show not just one last name but a few specific ones?

Thank you so much. You explain so good, clear and understandable. I wanted to ask please Is it also possible to do it in Google Sheet? I tried but unfortunately I didn't succeed.

when i choose few sheets with the shift button, and then the cells i want... it just saying #VALUE! error. i can only choose them individually how can i fix this? without choosing them separately

Hi, thank you very much for this great function , but plz how can i make data order by ascending

Nice tutorial, may I know if there any alternative way to do this without “filter” function? I am using the old version of excel 😢

Great formular, thanks! And can we show three column after filter such, Example I want to show First Name, Last Name and Age, Not show City

Not sure if you will see my comment, or anyone else, but is there anyway I can do another criteria? EG search last name and city? I tried to just do another * and bracket formula but that doesn’t seem to work?

This is exactly what I'm trying to study right now. Unfortunately, I dont have the VSTACK function yet.

LET function would be useful here too! nice video though

Great video. But how do I add partial search function instead of exact frase search?

HI, is there a way to do as you've done in this video but instead of using * we use OR function? I can't seem to make it work currently. I want to to have the option of selecting a filter (ie: b2, c2, d2 or just b2 etc...) thank you!

What if you don’t want all the columns but you just want some of the columns from the other sheets?

I'm getting #VALUE error. pls help

Here's my issue with the filter function. It makes the excel spreadsheet so large that I can't email or share it. You can't even upload it to a Google Drive to share because it's so large, not to mention that it takes a much longer time to open up. I have a spreadsheet that only has 419 rows in it, and 13 columns. And the initial size of it, before I used only one "Filter" command, was 262kb; but after I used only one "Filter" command in it, it increased to a size of 37,837KB. So my question is, is it typical for an Excel spreadsheet to increase dramatically when we use these new functions, because I usually create spreadsheets (especially at work) to share with others and colleagues, but if these new functions are making these Excel spreadsheets so large that you can't do that, then wouldn't it make more sense to use the old methods of massaging the data instead of using these new functions?