Hello,

I am looking to have a spreadsheet that lists "tickets" that were created and solved in a given date range. In the included example file there is data that is input (in grey) and the expected result is listed below. I am looking to list in one section all ticket numbers and their associated "subject" that were created in the given date range criteria, and all tickets in a separate section that were resolved in the given date range.

In the example I included what the expected result would be, however, I am unsure how to code this.

Help is appreciated. Thank you in advance.List ticket numbers - example.xlsx