Counting unique items in a range

F

Frank Kabel

Hi
think I 'captured' this formula from Peo Sjoblom: Use the
following array formula (entered with CTRL+SHIFT+ENTER):
=SUM(--IF(SUBTOTAL(3,OFFSET(A2,ROW(A2:A100)-MIN(ROW
(A2:A100)),,1)),(MMULT(((A2:A100=TRANSPOSE(A2:A100)
*TRANSPOSE(SUBTOTAL(3,OFFSET(A2,ROW(A2:A100)-MIN(ROW
(A2:A100)),,1))))*(ROW(A2:A100)>=TRANSPOSE(ROW
(A2:A100)))),ROW(A2:A100)*0+1)=1)))
 
Top