column data into column if value <>

  • Thread starter Thread starter tarzan
  • Start date Start date
T

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
 
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.
 
Back
Top