@BSherrill86
In general, that's not a good idea--to mix one kind of information in with another. In data processing there's an important concept called Data Integrity. Preserving data integrity is often compromised -- sometimes with disastrous results -- by this kind of casual practice.
When it's first done, it seems so easy and inconsequential...."Oh, since it's deleted we don't care any longer what kind of package it is, so let's just note 'Deleted' here under Package Type."
But (hypothetically) let's say that two years from now management asks "Is there a pattern on which types of package get deleted more often?" THAT'S when you realize you've actually destroyed some important information because you no longer can answer that question. The only answer from your database would be "The packages that get deleted are the packages that get deleted. We don't have any record to tell us how many 'Mechanical' or 'Hot Work' packages are deleted. Sorry."
Solution: Add another column that really is specifically to record order status (or whatever heading is most appropriate). If there only are two status levels, it could be very simple. But I can conceive of more possible status points: Pending, Wrapped, Labeled, Shipped, Returned, Deleted....
Design is important.
FILTER would still be my recommendation. But only after you've fixed your database design.
=FILTER(Datatable,Status="Deleted","none found") with the appropriate references in for the words "Datatable" and "Status"
I already gave you a YouTube video that explains FILTER.
Here's a website, if you prefer reading as a learning style. https://exceljet.net/excel-functions/excel-filter-function
I'd need to have access to your actual spreadsheet (not just an image) to write out the exact formula with the actual references in place. If you can post it on SharePoint or OneDrive or GoogleSheets, then I (or others here on this site) could take a look at it and give you more tailored answer.
