Nesting MIN and IF functions

mmiddleton

Hi, guys!

I am trying to create a function which will tell me the next date where a certain condition is met. I have a column called "Due" with due dates for a report and a column called "Received" with a checkbox. I would like to calculate the due date of the next report which has not already been submitted. 

To find the earliest due date I would use =MIN(Due1:Due10) and to count incomplete reports I would use =IF(Received1:Received10 = 0, ...) but I can't find a way to combine them. Is there another way to approach this?

Thanks for any advice!

rjudenberg

Try using the COLLECT function inside your MIN function

mmiddleton

That worked! Thank you so much!