View Single Post
  #3   Report Post  
seanc
 
Posts: n/a
Default frequency formula with criteria


Hi

It means the occurence of unique numbers in jan 05
is 2 ie no 1 appeared once and 2 appeard three times
but the unique count is only 2 ( the normal count for jan 05 would be 4
)

I hope that helps
thanks
Seanc


--
seanc
------------------------------------------------------------------------
seanc's Profile: http://www.excelforum.com/member.php...o&userid=28769
View this thread: http://www.excelforum.com/showthread...hreadid=484573