This version worked great and is much faster than the other formula!

Thanks,

Nick

"Daniel.M" wrote:

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