Extract list of data

[srmorgan]

I have a large file with part numbers and product codes in it.
I want to make a list of each unique product code and write it to a separate place, either a column on the same worksheet or another worksheet in the same file.
The file is sorted in product code order, it is just too big to do manually.

Can anyone help?

Thanks

Steve Morgan

 

[Aladin Akyurek]

On 2002-04-26 12:58, srmorgan wrote:
I have a large file with part numbers and product codes in it.
I want to make a list of each unique product code and write it to a separate place, either a column on the same worksheet or another worksheet in the same file.
The file is sorted in product code order, it is just too big to do manually.

Can anyone help?

Thanks

Steve Morgan

Use Advanced Filter where you check "Unique records only".

 

[srmorgan]

And then I copy it to another cell or column, I take it. Is that right?

 

[srmorgan]

Worked great!

Thanks

Steve`