Extract list of data

srmorgan · Apr 26th, 2002, 01:58 PM

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 · Apr 26th, 2002, 02:00 PM

Quote:

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 · Apr 26th, 2002, 02:11 PM

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

srmorgan · Apr 26th, 2002, 02:14 PM

Worked great!

Thanks

Steve`

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 26th, 2002, 01:58 PM	#1
srmorgan Board Regular Join Date: Apr 2002 Location: Wilmington North Carolina USA Posts: 61	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

Apr 26th, 2002, 02:11 PM	#3
srmorgan Board Regular Join Date: Apr 2002 Location: Wilmington North Carolina USA Posts: 61	And then I copy it to another cell or column, I take it. Is that right?

Apr 26th, 2002, 02:14 PM	#4
srmorgan Board Regular Join Date: Apr 2002 Location: Wilmington North Carolina USA Posts: 61	Worked great! Thanks Steve`