E1: 1-Jan-2014

F1: 31-Jan-2014

G1, control+shift+enter, not just enter:

H1, control+shift+enter, not just enter:Code:`=SUM(IF(FREQUENCY(IF($A$2:$A$6<>"",IF($B$2:$B$6>=$E1, IF($B$2:$B$6<=$F1,MATCH("~"&$A$2:$A$6,$A$2:$A$6&"",0)))), ROW($A$2:$A$6)-ROW($A$2)+1),1))`

Code:`=IFERROR(1/(1/MIN(IF($B$2:$B$6>=$E1, IF($B$2:$B$6<=$F1,$C$2:$C$6)))),"")`

## Like this thread? Share it with others