Please help!

I have a very old database at work that I can only export to excel 2010. I've tried various filters and renditions of IF statements within excel....and I don't even know if that is the way to attack this issue.

I am not an excel novice but I am not an expert either. I'm somewhere in the middle and need help.


Here is a sample of the spreadsheet...in its entirety it has several thousand records and many fields. This should have been set up differently from the start but too late now.

clsd file sample.xlsx

Here is my situation. We have boxes that contain files. Some contain one (1) file (identified by "case no")and others contain many files. I need a list of all of the box numbers where every file in that box has reached the "Date to destroy" date and the "Destroy or Return" field = "Destroy".

I keep running into problems because each box contains a different number of files.

Please help!