Greetings Folks!
Any notion of how I would add the criteria of 'Query 2 Data (Child Projects)'!$I$4:$I$40000<>"Cancelled" to this existing array in a file I have taken ownership of (and am not too familiar with how this functions)?
{=IFERROR(INDEX('Query 2 Data (Child Projects)'!$E$4:$E$40000,SMALL(IF('Query 2 Data (Child Projects)'!$B$4:$B$40000='Budget-Driven Spread Calculator'!$B$7,ROW('Query 2 Data (Child Projects)'!$B$4:$B$40000)-ROW($B$4)+1),ROWS($B$4:$B4))),"")}
Thanks in advance for your time and knowledge!!!!
Warmly,
Aimee
Any notion of how I would add the criteria of 'Query 2 Data (Child Projects)'!$I$4:$I$40000<>"Cancelled" to this existing array in a file I have taken ownership of (and am not too familiar with how this functions)?
{=IFERROR(INDEX('Query 2 Data (Child Projects)'!$E$4:$E$40000,SMALL(IF('Query 2 Data (Child Projects)'!$B$4:$B$40000='Budget-Driven Spread Calculator'!$B$7,ROW('Query 2 Data (Child Projects)'!$B$4:$B$40000)-ROW($B$4)+1),ROWS($B$4:$B4))),"")}
Thanks in advance for your time and knowledge!!!!
Warmly,
Aimee