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
|