View Single Post
  #14   Report Post  
Daniel.M
 
Posts: n/a
Default

You're welcome.

You may also try this one (also an ARRAY formula):

=SUM(--(FREQUENCY(IF(SUBTOTAL(3,OFFSET(A2,ROW(A2:A20)-ROW(A2),,1)),
MATCH(A2:A20,A2:A20,0)),ROW(INDIRECT("1:"&ROWS(A2: A20)))-1)0))

Regards,

Daniel M.

"Ndel40" wrote in message
...
That worked great!

Thanks,

Nick