<div>
<div class="content wysiwyg-content">
Hi Experts using excel 2010<br />
<br />
I have the following array Formula works fine..<br />
<br />
IFERROR(INDEX('Data Entry'!A$2:A$6,SMALL(IF('D<wbr />ata Entry'!$DI$2:$DI$6=1,IF('D<wbr />ata Entry'!$BF$2:$BF$6&gt;=$C$1,I<wbr />F('Data Entry'!$BF$2:$BF$6&lt;=$F$1,R<wbr />OW('Data Entry'!$BF$2:$BF$6)-ROW('D<wbr />ata Entry'!$BF$2)+1))),ROWS(A$<wbr />3:A3))),&quot;&quot;<wbr />)<br />
<br />
Need to add a step so if column AD (same data range) has the text C into above.
</div>
</div>


Hi Experts using excel 2010

I have the following array Formula works fine..

IFERROR(INDEX('Data Entry'!A$2:A$6,SMALL(IF('Data Entry'!$DI$2:$DI$6=1,IF('Data Entry'!$BF$2:$BF$6>=$C$1,IF('Data Entry'!$BF$2:$BF$6<=$F$1,ROW('Data Entry'!$BF$2:$BF$6)-ROW('Data Entry'!$BF$2)+1))),ROWS(A$3:A3))),"")

Need to add a step so if column AD (same data range) has the text C into above.

Array Formula to add additional step

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.