Auto-populate list given simple criteria?

[Tarheel8181]

See attached. I need a formula that will auto-populatea list of the task numbers (Column A on tab data source A) if the tasks are defined as Open (Column D).

 

[Luke M]

Array formula (confirm via Ctrl+Shift+Enter)
=IF(ROWS(A$2:A2)>COUNTIF('Indpt Data Source A'!$D$2:$D$11,"<>Closed"),"",INDEX('Indpt Data Source A'!A:A,SMALL(IF('Indpt Data Source A'!$D$2:$D$11<>"Closed",ROW('Indpt Data Source A'!$D$2:$D$11)),ROWS(A$2:A2))))

How it works:
http://chandoo.org/wp/2011/11/18/formula-forensics-003/

 

[Mike H..]

See attached. I need a formula that will auto-populatea list of the task numbers (Column A on tab data source A) if the tasks are defined as Open (Column D).

Hi,

See attached, I added a formula to indicate OPEN as well.

=IFERROR(INDEX('Indpt Data Source A'!$A$2:$A$1000,SMALL(IF('Indpt Data Source A'!$D$2:$D$1000="Open",ROW($B$1:$B$999)),ROW(1:1))),"")