You are most welcome!!! If you need additional automation, you can always try out VBA/Macros - here is my course that takes you from Beginner to Expert in VBA: www.teachexcel.com/vba-course-update.php?src=yt_comment_reply_hj6JSSQIrdw
FILTER is a wonderful function. Great tutorial. The period calculations are fantastic. I’m a current bill due date spreadsheet. Some of them are monthly, weekly, annually, etc. I’ll use yours a starting point. Thanks
Thanks Patrick, I'm really glad you liked the tutorial :)) FILTER is just so great, couldn't agree more! And definitely take my file and roll with it! I think that the setup should be flexible anough to change it around without much difficulty and the date formulas should also work well for many different combinations. I think when I get more time later this year I will make a small course on dates for Excel and how to get certain date periods, but, until then, feel free to ask for any help in getting your workbook up and running on the forum on TeachExcel.com
Thanks Darryl! And, man-o-man, I honestly didn't want to include it until I remembered that I did a whole tutorial on it in the past (I must have been crazy to do that hahaha).
Great video, thank you. I wish you also could include the This and Last Quarter as well. Anyone could you please let me know what formula/s we should use if we also need to include Quarters as well? I would appreciate it.
Thanks for this Tutorial. But please, my table array is not updating to the Table name as i selected the array when applying the filter function. What could be wrong?
Hi.. interesting approach. I've done something similar, but storing the live data in a proper Excel Table format (either copy and paste in or via Power Query) and then adding slicers for all the columns that I want to filter. For things like this/last month/year, it may require helper columns to get the functionality desired. Just another approach. Thanks for your tips.. always learn something :)) Thumbs up!!
I'm glad you like it Wayne :) And thanks for this great comment! I LOVE helper columns combined with the strategy that you mention and it is one of my favorite ways to make this kind of setup as well.
Very informative and useful video, thank you. I am trying to do something similar with dates in the future (next 10 days, next 5 days) how would I apply that to the formulas?
Hi, thank you for the interesting video. When I enter the formula with the "FILTER", the D2 gives me a #NAME? sort of error. It is definitely because I am using Excel 2016. The other thing is, when I use the IFERROR formula on the last part of your video, the formula does not populate the cells even if re-copy and re-paste all the formulas on the extent of the worksheet. But thank you.
hello, thank you for this tutorial. I would like to do something similar but the drop down would be "total year" then the name of the months. I can't wrap in my head what formula should I do. By the way, happy birthday to this video :D
having an issue, my cell displays N/A even though I did it exactly as you have so easily explained...hmmm?? =VLOOKUP(E3,TablePeriods,2,FALSE). Can you provide some sort of explanation so I can fix this? This will make my life so much easier...
I NEED HELP! PLZZ im trying to do something similar but more specific i guess. im a server and ive been working on an excel file to track my tips and sales percentages tip outs etc, it's very complex and im completely new to excel so it took me like two months. i'm trying to recreate an app that i was using but doesn't track enough details. in this app there are tabs on top for sorting the data yearly, monthly, weekly and biweekly and "all" and then at the bottom you can toggle between all of the data with arrows, between the 2 arrows there are 2 dates based off of the filter (the corresponding dates of the month, the week etc) but youre not limited to just "this month" and "last month", but you can continue to toggle between all months by clicking the arrow. i've tried with slicers and it kind of works but not as efficient or specific as i'd like it to be PLEASE TELL ME if you think that is at all possible on excel
Hi, I have a data where it has 7k customers' info for the complete year for paid and unpaid list. is there any formula or shortcut to know when was the last time the customer paid in which month and year?
This was a good tutorial but you lost me around the 17:55 mark because I'm using Google Sheets to budget (Excel's great but I need Sheets so that I can edit where ever I am, not just my personal computer). It's not as easy as Excel to create or name a table, I don't know where I went wrong because it keeps giving me error messages. Do you have explanation videos using Google Sheets? Thanks!
Great video, thank you. How about creating a dynamic report showing the totals in this format: This Month, Last Month and this quarter, last quarter and this year, last year at all times without any extra steps. something like a dashboard which always only automatically calculates and shows above mentioned values?
Hi, thank you for your teaching skills. Mine all works perfecty, but if i add Last 7 Days to dropdown and open and close, i get no sales. I checked the TableRaw and made sure their are dates in the last seven days, as i said all the other functions work EG.... this month, last month, this year, last year. I used =TODAY() - 7 , I get no report also tried =TODAY() - 14 and no results, missing something. Thank you guys
I watched your video on Date Filter Magic, and I think it is great. I would like to utilize it in my Budget & Check Register file. I am using Excel Version 16.54 for Mac. I would like to be able to track data on an ongoing basis, since I am constantly adding debits and credits to my check register, savings accounts, etc. Must I do anything special to make this work.
How would you zero in on a year you want to find specifically, such as having various years in an Excel Sheet with a lot of 2002, 2005, 2017, and 2021. You want to find the date 2021 specifically and highlight it all in a different color.
I thought I was the only one hiding stuff to make it look better. Btw, what happens if you print the entire sheet? Does the hidden columns and data in white font get printed?
I probably won't have to ability to fit such a tutorial in for a while but you could ask for some help for this on the forum on TeachExcel.com - I would also play around with the functions that I show you in this tutorial though because they can be used to make a wide range of date periods without tooo much difficulty.
I wish they would give an update for older versions and just allow it to be used in all of them back to 2007 - would be amazing! If you would like any help implementing the older formula in my tutorial, you can feel free to ask in the forum on TeachExcel.com and you can upload a sample file there as well.
![[LIVE] MCHOICE & MINT AWARDS 2024 at TRUE ICON HALL, ICONSIAM](http://i.ytimg.com/vi/wMewUeT5nbY/mqdefault.jpg)
Very original and creative case. Excellent tutorial. Thank you so much for sharing it.
Thank you Ivan, I'm happy that you think so, and I'm really glad that you liked it! :)
Thank you for this usuful video! I really need this to making report abour our budget! Thank you sooooo much
You are most welcome!!! If you need additional automation, you can always try out VBA/Macros - here is my course that takes you from Beginner to Expert in VBA: www.teachexcel.com/vba-course-update.php?src=yt_comment_reply_hj6JSSQIrdw
Thank you very much! This is exactly what I was searching for.
Just watched this. Thank you for explaining things in such an easy and clear way. 🥰
good video add very clear information
passion for creating the best content
FILTER is a wonderful function. Great tutorial. The period calculations are fantastic. I’m a current bill due date spreadsheet. Some of them are monthly, weekly, annually, etc. I’ll use yours a starting point. Thanks
Thanks Patrick, I'm really glad you liked the tutorial :)) FILTER is just so great, couldn't agree more! And definitely take my file and roll with it! I think that the setup should be flexible anough to change it around without much difficulty and the date formulas should also work well for many different combinations. I think when I get more time later this year I will make a small course on dates for Excel and how to get certain date periods, but, until then, feel free to ask for any help in getting your workbook up and running on the forum on TeachExcel.com
Excellent! Thank you!
Absolutely awesome tutorial!!!! Thank you.
Thank you so much for your comment!!! I'm very glad you like it :))
I giggled when you titled your sheets R2 D2 :)
What’s so funny about it?
Great Tutorial On The Simply Awesome FILTER Function...Thank You Sir :) P.S Still Get A Headache Looking At The Scary Old School Formula!!
Thanks Darryl! And, man-o-man, I honestly didn't want to include it until I remembered that I did a whole tutorial on it in the past (I must have been crazy to do that hahaha).
That's amazing sir
Man thank you very much!!!
This was beautiful, thank you so much!!
Excellent !!!!
Very Educative
Great video, thank you. I wish you also could include the This and Last Quarter as well. Anyone could you please let me know what formula/s we should use if we also need to include Quarters as well? I would appreciate it.
Very helpful tutorial. Thank you so much!!
I'm glad you think so! You are very welcome Hang!
Thank you so much
You are very welcome!
Thanks for this Tutorial.
But please, my table array is not updating to the Table name as i selected the array when applying the filter function. What could be wrong?
It is great. Help me a lot
Thank you it really helped
Tutorial very useful tutorial
Hi.. interesting approach. I've done something similar, but storing the live data in a proper Excel Table format (either copy and paste in or via Power Query) and then adding slicers for all the columns that I want to filter. For things like this/last month/year, it may require helper columns to get the functionality desired. Just another approach. Thanks for your tips.. always learn something :)) Thumbs up!!
I'm glad you like it Wayne :) And thanks for this great comment! I LOVE helper columns combined with the strategy that you mention and it is one of my favorite ways to make this kind of setup as well.
Excellent tutorial! Thank you :-)
Thank you
hello, I did it but only the first row is showing, i can see the formulas below but it is not showing the data. what am i doing wrong?
I have copied formula in all cells. But from second row result blank. What wrong here? I have followed your excel file also. My Excel verison 2010
Awesome 🙏
Glad you like it :))
Very informative and useful video, thank you. I am trying to do something similar with dates in the future (next 10 days, next 5 days) how would I apply that to the formulas?
Very nice sir 👍👍👍👍
I made IF Error INDEX formula, but no data is showing at the place of formula.
Nice video man, this is truly useful. Gonna save it in my excel folder =)
pro tip : watch movies at Flixzone. Been using it for watching all kinds of movies these days.
@Mohamed Ezequiel Yea, been using flixzone} for years myself :)
Can you doo this if you want too see the overall "general data", and still be able to filter out what particular year you would like too see.
Hi, thank you for the interesting video. When I enter the formula with the "FILTER", the D2 gives me a #NAME? sort of error. It is definitely because I am using Excel 2016. The other thing is, when I use the IFERROR formula on the last part of your video, the formula does not populate the cells even if re-copy and re-paste all the formulas on the extent of the worksheet. But thank you.
Good jub hehehe, i like when zooming, please create simple pos program,
how can i dynamically analyse off of this information?
hello, thank you for this tutorial.
I would like to do something similar but the drop down would be "total year" then the name of the months. I can't wrap in my head what formula should I do.
By the way, happy birthday to this video :D
having an issue, my cell displays N/A even though I did it exactly as you have so easily explained...hmmm?? =VLOOKUP(E3,TablePeriods,2,FALSE). Can you provide some sort of explanation so I can fix this? This will make my life so much easier...
I NEED HELP! PLZZ
im trying to do something similar but more specific i guess.
im a server and ive been working on an excel file to track my tips and sales percentages tip outs etc, it's very complex and im completely new to excel so it took me like two months.
i'm trying to recreate an app that i was using but doesn't track enough details.
in this app there are tabs on top for sorting the data yearly, monthly, weekly and biweekly and "all"
and then at the bottom you can toggle between all of the data with arrows, between the 2 arrows there are 2 dates based off of the filter (the corresponding dates of the month, the week etc) but youre not limited to just "this month" and "last month", but you can continue to toggle between all months by clicking the arrow.
i've tried with slicers and it kind of works but not as efficient or specific as i'd like it to be
PLEASE TELL ME if you think that is at all possible on excel
Hi, I have a data where it has 7k customers' info for the complete year for paid and unpaid list. is there any formula or shortcut to know when was the last time the customer paid in which month and year?
This was a good tutorial but you lost me around the 17:55 mark because I'm using Google Sheets to budget (Excel's great but I need Sheets so that I can edit where ever I am, not just my personal computer). It's not as easy as Excel to create or name a table, I don't know where I went wrong because it keeps giving me error messages. Do you have explanation videos using Google Sheets? Thanks!
Any chance you could let me know how to add Quarters as well? This Quarter, last Quarter please?
very informative. i ave older version of excel. and i dont have =filter. can you pls teach us how to do it?
.
Do you have any idea on how to get This week and Last week data?
Great video, thank you. How about creating a dynamic report showing the totals in this format: This Month, Last Month and this quarter, last quarter and this year, last year at all times without any extra steps. something like a dashboard which always only automatically calculates and shows above mentioned values?
Hi, thank you for your teaching skills. Mine all works perfecty, but if i add Last 7 Days to dropdown and open and close, i get no sales. I checked the TableRaw and made sure their are dates in the last seven days, as i said all the other functions work EG.... this month, last month, this year, last year. I used =TODAY() - 7 , I get no report also tried =TODAY() - 14 and no results, missing something. Thank you guys
I watched your video on Date Filter Magic, and I think it is great. I would like to utilize it in my Budget & Check Register file. I am using Excel Version 16.54 for Mac. I would like to be able to track data on an ongoing basis, since I am constantly adding debits and credits to my check register, savings accounts, etc. Must I do anything special to make this work.
Hi new sub here. Just have one question, is there a way to lovk a column after each day has passed? Thanks in advance!
How would you zero in on a year you want to find specifically, such as having various years in an Excel Sheet with a lot of 2002, 2005, 2017, and 2021. You want to find the date 2021 specifically and highlight it all in a different color.
Great video. May I check how to extract my data if my data consists of a start date and end date?
How to do this in Google Sheets?
Why not using advanced filter with old version ?
how about specific date?
The =filter option is not showing up anyone has idea how to get
I thought I was the only one hiding stuff to make it look better. Btw, what happens if you print the entire sheet? Does the hidden columns and data in white font get printed?
Can you demonstrate or explain formulas using fiscal months and years, instead of calendar years?
I probably won't have to ability to fit such a tutorial in for a while but you could ask for some help for this on the forum on TeachExcel.com - I would also play around with the functions that I show you in this tutorial though because they can be used to make a wide range of date periods without tooo much difficulty.
Where is YTD? 😢
sad that my excel version still dont have the filter formula :'(
I wish they would give an update for older versions and just allow it to be used in all of them back to 2007 - would be amazing! If you would like any help implementing the older formula in my tutorial, you can feel free to ask in the forum on TeachExcel.com and you can upload a sample file there as well.
👍👍👍👍👍
Poor…