mahju,
thank you for your response. I am afraid those formulas do not achieve the desired results. The 1st Description of the desired results does return correctly, but not necessarily the rest or the complete desired date range. Thank you very much for the effort.
JBeaucaire,
I apologize for not including enough data to start. I have added a few rows to the data set as well as a second possibility for desired results. Hopefully this will give a more complete picture of what I am looking for.
You can see that there will be multiple descriptions for a given date.
The Start and End dates will be manually entered so that I can choose a date range to summarize.
I will need to print out this summary on a weekly basis. The data set will likely have over 1,000 entries by years end, but I would still like to be able to pull descriptions within a given date range and print it out without spaces between the descriptions.
I guess I am basically looking to replace the manual action of sorting by date on the data sheet, copying the descriptions within the desired range and pasting on a summary sheet. There are other calculations for the given date range that are included on that summary as well that I have already figured out.
thanks again for your help and please let me know if you need any additional information.
Attachment 141086DummyWorkbook_updated.xlsx
Bookmarks