Awesome tutorial, thank you for the concept of dynamic dates (YTD, previous month, previous year,....). It would be great you had a date picker there. A great trick I have just learnt to apply the filter, once u defined the rule, just right click and select filter by color, instead of the filter drop down list and box
Hi Debra.. great tips.. thanks for the video. Here is another one.. use Advanced Filter to Filter By Formula. So, take the formula you created for the conditional formatting and put it in cell I2: =AND(B4>=$G$2,B4
Thanks, Wayne, and I've been a big fan of Advanced Filters for many years! You can see some of my criteria formulas (and a couple of my older videos) here: www.contextures.com/xladvfilter02.html
Great video have been banging my head for a while about this. But how to do when you have date and time in two different cell and you want to apply this filter formula?
Awesome tutorial, thank you for the concept of dynamic dates (YTD, previous month, previous year,....).
It would be great you had a date picker there.
A great trick I have just learnt to apply the filter, once u defined the rule, just right click and select filter by color, instead of the filter drop down list and box
Neat use of conditional formatting!
Thanks, Doug!
I love all your videos and your soothing voice teaches in an easy to follow, well explained way . Appreciate you sharing your knowledge
Thank you so much!
Thank you, this is a simpler idea than what I was over thinking
You're welcome, Eryck, and thanks for your comment!
Hi Debra.. great tips.. thanks for the video. Here is another one.. use Advanced Filter to Filter By Formula. So, take the formula you created for the conditional formatting and put it in cell I2: =AND(B4>=$G$2,B4
Thanks, Wayne, and I've been a big fan of Advanced Filters for many years! You can see some of my criteria formulas (and a couple of my older videos) here: www.contextures.com/xladvfilter02.html
What if i want to exclude some dates between the start and end dates that I selected?
It's wondeerful!
Thank you!
Your the best , thank you
Aw, thank you, Insaf! 😊
YOU ARE THE BEST
Your best, thank you
You're welcome, Bayarmaa, and thanks for your comment!
How can I use Slicers to Filter Data Betweeen Two Dates in Excel ?
Add a new column in the data, with a formula that checks if date is in date range. Then, add a slicer for that column, and filter for TRUE
@@contextures Thanks but hard for me to visulaize. Could you please share a screenshot or template?
Slicing between periods, month, quarters, semester and year.
Create aditional columns for those periods.
Month = text(date, "mmm")
Quarters = ifs(date
Effective video
Thank you!
Thank you
Great video have been banging my head for a while about this. But how to do when you have date and time in two different cell and you want to apply this filter formula?
Good illustration.
Can we do this with advance filter?
Thanks you mam
You're welcome, Rahul, and thanks for your comment!
Hep me value grand total pivot tab not match when the creat fieds .
HERE, CAN WE SEE THE RESULT AS SOON AS WE CHANGE THE DATE AND WITHOUT REFERESHING
Thanks for your question, and the AutoFilter does not automatically refresh.
How this sales data table create
This video shows how to make a formatted table:
ruclips.net/video/AM7iUCYSUrw/видео.html