What is the formula if l need to pull out the same from one more sheet? or how to combine two filter functions as the other is using a different condition?
I keep getting a #calc! error. It worked on a completely blank sheet, but not when trying to enter it on an existing sheet. I started off with spill errors?
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?
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.?
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!
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
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.
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!!!!
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.
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!!