Thread: Unique Counting With Multiple Criteria
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Morton Detwyler[_2_] Morton Detwyler[_2_] is offline
external usenet poster
  
Posts: 33
Default Unique Counting With Multiple Criteria
Exactly what I was looking for...thank you so much!

"Bernd P" wrote:

Hello,

I suggest to enter into
D2:
=IF(C2<C1,0,(B2<B1)+D1)
and copy down.

Regards,
Bernd

Reply With QuoteReply With Quote