SURPRISING Advanced Filter TRICK in Excel (You've Never Heard Of!)

Great

Can you put an advanced filter on a new sheet. Then update the dataset and have that new information automatically filter to the desired sheet?

You just saved hours of frustration. Thanks!

What if I want everything in a column except for one or two variables?

No

Using the filter function in Google Sheet for centuries and you can show any column you need.

I knew this, but lost my notes on how to do it. I'm glad this is the first video I watched—so concise! :)

Hi, its nice.. i want to know in date range how to add the dates in between. Example : i need a data filter 27-01-2023 to 27-02-2023 means how to add?

No, but I do now. Thanks!😀

No

Bless you

YES.

Yes!

No, I did not know. Thanks for sharing. I’m going to look it this.

no

Nope....didnt know that part even after using xl for 20 yrs

No

No I don't know thanks for sharing

I did not know that either. Thank you for sharing. ❤ your kindness to keep teaching us.

I don't know this before. What an awesome trick.!

Yes

Good one, thank you

To be honest my reaction was:

"NOOOOOOOOOO"

when I realized it does filter and give you back the desired columns at the same time.

Amazing

Nice one Leila.

Would it be possible to replicate this method in VBA? If I have multiple criteria's, would it be possible to split the data into separate worksheets?

No... I didn't knew it.... Thanks for this video.

No

These are more advanced now with the "Filter" function in excel

Awsome

Hello @LeilaGharani , how to make this dynamic when i have new entries in my data set to that the filter always work.

No

🤯🤯

No

no

No, was using only to copy single records. Simply Fantastic…

Yes

Yes

I heard it before its old 😅

Yes - I had used this trick before retiring several years ago.

no

Hi Leila, GREAT INFORMATION. THANK YOU FOR ALL THE LESSONS YOU HAVE SHARED. ONE LOVE and RESPECT. IF you visit JAMAICA give me a shout out. I do not know if you can point me to solve an issue I have, where I would like to FILTER a DATA SHEET into multiple sheets based on values in a [Colum = Sales Person Name]. Hence each Sales Person would have their own sheet or even better an excel spreadsheet. I can "NOW" do this "Manually", but would love to automate same.

Very, Very good TRUC, thanks a lot Leila!

I knew this alredy.

I have covered of the simple tricks at my channel as well

Tell me how do I move a colon behind or in front another apart from copy and paste..please.

Thanks never used it didn't know it

No

Sometimes I wonder about the creation of Excel and what was planned and what was a happy accident...

No