Hi,
So I need to count the unique entries in column D but only after 1st August 2013.
The formula I have come up with is:
=SUM(IF(FREQUENCY(IF(Projects!$U$1:$U$1328 >=1/8/2013, IF(Projects!$D$1:$D$1328<>"",MATCH(Projects!$D$1:$D$1328,Projects!$D$1:$D$1328,0))),ROW(Projects!$D$1:$D$1328)-ROW(Projects!$D$1)+1),1))
But for some reason this is counting ALL the unique values in column D regardless of date. Can anyone tell me what I have done wrong?
Thanks!
Mish
Bookmarks