List Differences

S

sparx

Hello All, I have a column with hundreds of entries consisting o
approx twenty different number values ( very random locations ) ie. 00
or 343 or 552 etc - how can I produce a column that will list only on
of each of the values but in an ascending order? any help would b
appreciated
 
S

sparx

Thanks for your reply - but to no avail.
I tried all the options but nothing worked for what I needed.
If I describe what my worksheet consists of - maybe that will shed some
light.
I have a form that works like a quote document and a macro that copies
all that quote detail to a worksheet - this worksheet consists of
columns of data, date, quote ref, materials, etc etc. One column is a
commodity reference for expendiature that is made up of 3 numbers or
could be text - ie SPIPE or 043 could be Steel Pipe - these numbers
could appear loads of times or not at all and could be in any order -
starting in column Z ( Z3 ) and working down. I want to create a list
in any other column that looks down column Z3 to Z5002 and lists each
reference in turn - not the number of times say 043 appears but will
create a column say Y3=033 Y4=034 Y5=043 Y6=833 Y7=982 and so on but in
ascending order. If there are text references then they should be
listed too. I dont know if a macro could do this sort of thing or if
formula's need to be used.
 
Top