Thread
:
Finding unique numbers in a column
View Single Post
#
3
Nick Hodge
Posts: n/a
To identify the number of dupes, say in A1:A1000 then use this formula in
another column (Say E2 and copy down)
=COUNTIF($A$1:$A$1000,A1)
Other ways of handling dupes can be found here
http://www.cpearson.com/excel/duplicat.htm
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS
"coolkid397" wrote
in message ...
Is there any way to find the number of unique values among a set of
values in a column in an excel sheet. I would also like to know the
number of times each value appears in the column.
Thanks
--
coolkid397
------------------------------------------------------------------------
coolkid397's Profile:
http://www.excelforum.com/member.php...o&userid=24319
View this thread:
http://www.excelforum.com/showthread...hreadid=379248
Reply With Quote