Excel: Counting unique number


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
Please assist with this problem. Thank you much, madhatter


This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of April 06, 2015.


For more resources for Microsoft Excel