Extract unique items based with added variable

[kk1352]

Hi all,

I’m trying to find work out a formula to determine the number of unique items there are in a list with added variables in a parallel columns. E.g. determine the number of unique items if that item is in group 2 and it occurs between 2 dates

I have attached an example file.

Any help would be greatly appreciated.

Thanks

[FDibbins]

You have banana spelled 2 ways (also bannana row 14)

This works if you add a helper column...
=COUNTIFS($A$2:$A$15,">="&$E$2,$A$2:$A$15,"<="&$F$2,$C$2:$C$15,H2,$D$2:$D$15,1)

I added a helper column in D and used this...
D2=COUNTIF($B$2:B2,B2)
copied down
You can hide this if you want to