Glad you gave an example because 93-1122 is not really a number
Try using Data | Filter
And/or visit Chip site which has lots on duplicated
http://www.cpearson.com/excel/duplicat.htm
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dark_Templar"
wrote in message
news:Dark_Templar.26f11d_1145289008.3957@excelforu m-nospam.com...

I ran into a problem I have no solution for - I hope one of you has.

I have column A filled with certain numbers, some are the same, some
are different. (see example.xls)

I would like to put out all numbers to column B, that are different.
Ie: "93-1122" is 7 times in col A - I want it, along with all other
numbers, to show up in col B..just once.

How would I be doing that?

Thanks in advance.


+-------------------------------------------------------------------+
|Filename: Example.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4646 |
+-------------------------------------------------------------------+

--
Dark_Templar
------------------------------------------------------------------------
Dark_Templar's Profile:
http://www.excelforum.com/member.php...o&userid=33279
View this thread: http://www.excelforum.com/showthread...hreadid=533446