I have the following formula that is returning VALUE!
{=INDEX($E$11:$F$11104,$E$6,MATCH(1,($D$11:$D$11104>=$D$6)*($D$11:$D$11104<=$D$8),1))}
Columns E & F are populated with surnames, E6 is the surname that is being identified (counted), column D are the Date values, i.e. Fri-17-Feb-12, D6 is...