column data into column if value <>

[tarzan]

I have on sheet1 a column with thousands of numbers, some
equal some not.
On sheet2 I'm trying to get from that column only the
numbers that are different and sort them.

Sheet1 ---> Sheet 2
Column1 Column1
2345 2345
2345 1234
2345 How can I do this? 1236
1234 1237
1236
1237
1237

 

[J.E. McGimpsey]

See answer to your previous post ("collect all different numbers
from column and sort them").

Please don't start another thread - it just fragments your answers
and potentially wastes the time of those replying. See

http://cpearson.com/excel/newposte.htm

for tips on using these newsgroups effectively.