So you've got a bunch of data on one sheet and you would like only a certain date range to appear on a separate sheet. Here's a super simple way to achieve that! If you like the video, please subscribe! I appreciate all of you!
I have literally spent 2 hours looking through so many very difficult tutorials on how to get this done (seeming impossible without using VBA... which is not my strength) and I will be very transparent and honest and let you know that I got a bit teary eyed at the end of your 4 minute video because your video SAVED me!!! I was skeptical because all the previous videos were well over 10 minutes... but, it worked exactly like I needed it to and it was so super easy and so understandable... YOU ABSOLUTELY ROCK!!!!
I've been trying to create my own Account Register / Spend Tracking solution using a Google Form as the input (because adding entries to a Google sheet on a smartphone sucks!) and this has made it possible for me to import the data collected by the form into other sheets with ease! Thank you, thank you, thank you!!
Yo!🎉 this is amazing! I used this exact same formula to extract data from a sheet that records every hour for and entire month this thing will save me hours of work!!!
Finally found an easy video to get me to where I need for a project I’m currently working on with a lot of data! SO, I see that this filters by a date range. Keeping with what you did, is there a way to filter by a specific day of the week based on the date range? Thank you.
question I have an idea and was wondering if its possible or if you might have an idea. I use excel to document monthly check list is it possible to have a sheet be my main check list and other sheets that are each month to auto update or pull the data if todays date or current date is in that month?
Can I use this but for more than one sheet? I have 5 sheets and on each one ppl adds data with a date. I want to pull only the last date data and show it together
Any idea on how to make this work, but based on another date in another column? As in, filter if specified date range is in this column OR this column.?
Is there a way to do this so it pulls the data automatically whenever a new line is added? I have a sheet where new stuff is always added to it and I want a different sheet per month for the values to move over to it. So this filter function but done automatically whenever a new row is added with qualifying information on the date range.
This formula should pull all new rows as long as you don't change it to only read a certain range. Example A1:DJ50 only. If you leave it just A:DJ that should essentially ready every new row on your sheet :)
I've been looking for this way for some time. I have a commission worksheet that I want to return all the records between two dates. Since I have a 'Deposit' payment and a 'balance payment' this isn't totally how I want it, but it's 98% of the way home. Thanks!!!!
So, I don't have an easy way for this YET, however you could do something like this =FILTER('All Scores'!A:AZ,'All Scores'!DJ:DJ="May") It is saying, view the sheet titled 'All Scores', the dates (in your case month only) appear in column DJ. Search that column and pull everything with the month May in my example. I am sure you have found the answer by now however wanted to reply in case others are struggling.
Could anyone help me as instead of getting an error message I just get a '0' from this formula. I made sure to copy and paste the formula provided in the comments and can confirm the cells are set as date instead of general. Not sure why it doesn't work. Any help would be appreciated!
@@exceltipstricks6084 I know all to well what a new baby is like, I had four myself and helped raise three more. My last one is almost out of the nest. Enjoy those moments because one day you will find yourself with too much time on your hands and be bored out of your mind. Happy Parenting!
What if you have hundreds and thousands of criteria of data you want to sort from your master spreadsheet to various sub-spreadsheets? Is there a single formula to do it?
@@exceltipstricks6084Many thanks for your prompt reply. Seems like I can’t send a picture here otherwise I could show you what I mean. I have a massive table in a excel spreadsheet where one of the column contains the criteria of “company”. The names of the companies being A, B, C, etc etc. (There are thousands of company names, some names have a few entries, some only have a single entry) Each company name is required to be extracted into a standalone spreadsheet. With the method described in the video, I will need to create thousands of spreadsheets and type thousands of formula. I just want to know if there is a single formula that does the trick? Thank you so much in advance.