It's not clear exactly how you want it to look, but you could use something like the table in my attachment, which uses:
=IFERROR(INDEX($F$2:$F$50,SMALL(IF(COUNTIF($H$2:$H2,$F$2:$F$50)=0,ROW($F$2:$F$50)),ROW(1:1))-1),"")
...filled down to return the names. The formula should be array-entered (Ctrl + Shift + Enter). Then the following for the data:
=COUNTIFS($F$2:$F$50,$H3,$C$2:$C$50,">="&$I$1,$C$2:$C$50,"<="&$K$1,$D$2:$D$50,I$2)
Fill right and down. See the attachment for a clearer picture:
EDIT: You can change the dates in row one to select a different date range
Bookmarks