View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dark_Templar
 
Posts: n/a
Default Put out numbers that are different?


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