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

Dark_Templar Wrote:
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.


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