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.