Counting unique number

[madhatrs26]

I have an issue with trying to find a formula that can count the unique number in a list. Here is the data so referencing column A and counting the unique number in column B.

USER_ID	LABEL
axr681	0321423846
axr681	0321423846
axr681	0321423859
mxf358	0321423850
mxf358	0321423852
mxf358	0321423852
mxf358	0321423852
mxf358	0321423867
rxv829	0321423851
rxv829	0321423851
rxv829	0321423864
tmj255	0321423849
tmj255	0321423849
tmj255	0321423849
tmj255	0321423861

<colgroup><col><col></colgroup><tbody>
</tbody>

Please assist with this problem.

Thank you much,

madhatter

 

[krykm]

Sorry I just saw your post, but thanks to Mr Aladin, he already came up with a great solution.

With all due respect to him, maybe that formulas below could be alternatives;

=SUM(IFERROR(--(MATCH(IF($B$2:$B$16<>"",$B$2:$B$16),IF(A2=$A$2:$A$16,$B$2:$B$16),0)=ROW($C$1:$C$15)),0)) Ctrl+Shift+Enter
=SUMPRODUCT(--($A$2:$A$16=A2),IFERROR(1/COUNTIFS($B$2:$B$16,$B$2:$B$16,$A$2:$A$16,$A$2:$A$16),0)) Ctrl+Shift+Enter

Regards

 

[Aladin Akyurek]

Sorry I just saw your post, but thanks to Mr Aladin, he already came up with a great solution.

With all due respect to him, maybe that formulas below could be alternatives;

=SUM(IFERROR(--(MATCH(IF($B$2:$B$16<>"",$B$2:$B$16),IF(A2=$A$2:$A$16,$B$2:$B$16),0)=ROW($C$1:$C$15)),0)) Ctrl+Shift+Enter
=SUMPRODUCT(--($A$2:$A$16=A2),IFERROR(1/COUNTIFS($B$2:$B$16,$B$2:$B$16,$A$2:$A$16,$A$2:$A$16),0)) Ctrl+Shift+Enter

Regards

But of course, in particular when they fit the performance bill, along with the admissible generality and flexibility scrores:

See an early evaluation: http://www.mrexcel.com/forum/excel-questions/292473-performance-formulas-unique-count.html

 

[krykm]

Thank you very much Mr. Aladin for such an useful information. That issue becomes much more important when we have too many data in our worksheets.

Best Regards

But of course, in particular when they fit the performance bill, along with the admissible generality and flexibility scrores:

See an early evaluation: http://www.mrexcel.com/forum/excel-questions/292473-performance-formulas-unique-count.html