Hello Sandramv and Welcome to Excel Forum.
This is how an array entered formula* might be used to get the list of records meeting the conditions of "Column R is <=today's date [and not blank] and column T is = 0" (as shown on sheet 2).
Formula:
=IFERROR(INDEX('Project Ready'!B$2:B$5241,SMALL(IF(('Project Ready'!$R$2:$R$5241<=$A$1)*('Project Ready'!$R$2:$R$5241<>"")*('Project Ready'!$T$2:$T$5241=""),ROW($2:$5241)-1),ROW(1:1))),"")
Note: Date is placed in cell A1.
*Array entered formulas are confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Let us know if you have any questions.
Bookmarks