View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sam via OfficeKB.com Sam via OfficeKB.com is offline
external usenet poster
 
Posts: 247
Default Match Criteria & Return Sequential Count

Hi Mike,

Thanks for reply.

The zero in row 40 represents the match of all criteria in the order stated.
The count should reset to 1 in the row after the zero (0) when all criteria
is met.

Cheers,
Sam

Mike H wrote:
Sam,


Please explain again why the count reset to zero in Row 40


Mike


--
Message posted via http://www.officekb.com