Hi. You can use this:
=IFERROR(INDEX(ORDERDISPLAY!$A:$A,AGGREGATE(15,6,ROW(ORDERDISPLAY!$AO$5:$AO$5000)/((TEXT(ORDERDISPLAY!$D$5:$D$5000,"mmmm")=$D$4)*(ORDERDISPLAY!$AO$5:$AO$5000=$C$7)),ROWS($A$11:A11))),"")
You'll need ; instead of , and will need to change the bit in red to $C$6... as Januari isn't recognised as a month in my locale!!
Bookmarks