Help with Excel 2010 data extraction

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!

Thanks HaHoBe-

I only need the box # if every file in that box meets the date and destroy criteria...so if one file in the box does not meet the date and destroy criteria, I don't want that box #.

I tried the filter as you said but that did not work because of the fact that I need EVERY file in the box to meet the criteria....it was giving me the boxes that had files that did meet the criteria but not every file.


Hope you can follow this.

Thanks for the suggestion Holger but I either need a little more info or I'm not understanding.

If I extract a list of unique box numbers I will be missing a large number of the records. For instance, if box #1 contains 20 files (which is actually 20 records or 20 rows) it will only show one record/row in the filtered list. That particular record might meet my criteria but the other 19 files in that box (19 other records/rows) don't meet the criteria so I don't need that box #.