List Differences

[sparx]

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

[Niek Otten]

http://www.cpearson.com/excel/deleti...eDuplicateRows

--
Kind regards,

Niek Otten

"sparx" <[email protected]> wrote in message
news:[email protected]...
>
> Hello All, I have a column with hundreds of entries consisting of
> approx twenty different number values ( very random locations ) ie. 002
> or 343 or 552 etc - how can I produce a column that will list only one
> of each of the values but in an ascending order? any help would be
> appreciated.
>
>
> --
> sparx
> ------------------------------------------------------------------------
> sparx's Profile: http://www.excelforum.com/member.php...o&userid=16787
> View this thread: http://www.excelforum.com/showthread...hreadid=531808
>

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