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? :confused:

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

Put out numbers that are different?
 

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? :confused:

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

Put out numbers that are different?
 

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? :confused:

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

Put out numbers that are different?
 

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:D$65536,A2)-COUNTIF(A2:D$65536,A2)=0,A2,"")


--
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