I am trying to find all of the Imprint Orders on December18 and create a list on Sheet2 using the array formula
=IF(ROWS(A$3:A3)<=$C$1,INDEX(December18!$D$1:$DX$1,SMALL(IF(December18!$D$5:$DX$5=$B$1,ROW(December18!$D$1:$DX$5)-ROW(December18!$D$1)+1),ROWS(A$3:A3))),””)
I get 15 results but they are all of the first order which is not marked "Imprint".
Bookmarks