My issue is that I need an OR criteria on the range, I need the smallest project number that has any old debt outstanding. I'm trying to get a function similar to these (except one that works!): It is perfect for creating basic documents, spreadsheets, and presentations, and is a great choice for students and home users. To do that, I'm trying to find the first value and I can't figure this part out. This edition is designed for individuals who need essential Office applications like Word, Excel, and PowerPoint for personal use. I'm calling the data values on the Data! tab and trying to list them in numerical order with the minifs function. That is, column L has the amount of money owed that is less than 60 days outstanding, column M has the money owed that is 61-90 days old, and column N has money owed that's more than 90 days old. I have a data query which pulls data into my Data! tab, the query returns the age of the invoices in date range buckets (eg 90 days). I'm trying to create a list of unique project numbers that have outstanding invoices.

Minifs excel 2013