Put out numbers that are different?

[Dark_Templar]

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, som
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 othe
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
+-------------------------------------------------------------------

 

[Clivey_UK]

Put a column heading in A1, and then click in any cell in the range and
do Data/Filter/Advanced Filter. Choose Copy Unique Records only and put
B1 in the Copy To field.
N.B. Excel sees the entries in column A as text (931122 would be a
number but 93-1122 is a text in the same way that 93A1122 is). However
that doesn't affect the Filter. It's just FYI.
Clive

 

[Bernard Liengme]

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" <[email protected]>
wrote in message
news[email protected]...

 

[Dark_Templar]

Will try that - Thanks.

I have just found this Thread:
http://www.excelforum.com/showthread.php?t=533259

This function works fine too:
=IF(COUNTIF(A$2$65536,A2)-COUNTIF(A2$65536,A2)=0,A2,"")