Displaying Findings of CountIF

Unmerge the cells or this won't work

in D10
=IFERROR(INDEX($B$2:$B$100,SMALL(IF(($A$2:$A$100>=D$2)*(A$2:A$100<=F$2),ROW($A$2:$A$100)-1),ROW(A2)-1)),"")
and copy down the column

NOTE: Array formula, use Ctrl-Shift-Enter

I suggest that you post a sample workbook that is more representative of the real workbook. That way a solution can be offered that you will not need to adapt.

Originally Posted by clprdctn

Sorry - I'm trying to apply this to my non-test spreadsheet but I must be doing something wrong as i'm getting blank:

=IFERROR(INDEX(XXC!$B$56:$B$99,SMALL(IF((XXC!$D$56:$D$99>='DO NOT MODIFY-DELETE'!$A$16)*(XXC!$D$56:$D$99<='DO NOT MODIFY-DELETE'!$B$16),ROW(XXC!$D$56:$D$99)-1),ROW(XXC!$D$56)-1)),"")

Try it like this and make sure you array enter**.

=IFERROR(INDEX(XXC!$B:$B,SMALL(IF((XXC!$D$56:$D$99>='DO NOT MODIFY-DELETE'!$A$16)*(XXC!$D$56:$D$99<='DO NOT MODIFY-DELETE'!$B$16),ROW(XXC!$D$56:$D$99)),ROWS(A$1:A1))),"")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.