formula for unique numbers

[vimalanathk]

Hi,

I am herewith attaching my request. please help me with the formula which i can use for this query.

Regards,
Vimala K

[Limor_OP]

Hi,

Please try this:
=SUM(--(IF(MATCH(IF(B2:B13>0,A2:A13),IF(B2:B13>0,A2:A13),0)*($B$2:$B$13)>0,MATCH(IF(B2:B13>0,A2:A13),IF(B2:B13>0,A2:A13),0)*($B$2:$B$13))=ROW($B$1:$B$12)*($B$2:$B$13)))

[José Augusto]

Deleted by the author.

[CARACALLA]

B15=SUM(IF(FREQUENCY(IF(B2:B13>0,MATCH(A2:A13,A2:A13,0)),ROW(B2:B13)-ROW(B2)+1),1))

Control+Shift+Enter

[Phuocam]

Or try:

=SUM(IF(B2:B13>0,1/COUNTIFS(A2:A13,A2:A13,B2:B13,"<>0")))

Enter with Ctrl+Shift+Enter.