Get external data question

Chartman of the Bored · May 16th, 2002, 03:18 PM

Hi,

I'm trying to set up a spreadsheet that will download data from a web page and refresh each time it's opened, and then delete duplicates. The data is at the link below and is actually a text delimited file located on the web.

http://www.nasdaqtrader.com/dynamic/SymDir/mrktsym.txt

I've managed to set up a spreadsheet which already does the text-to-columns part and I can refresh by hitting the exclamation (!) refresh button under the "Data" menu. However, there are lots of duplicate rows for the same company (a new row for each location of the company). I need to get rid of the duplicates -- hopefully automatically each time the spreadsheet is opened and refreshed.

Thanks in advance for any help.

brettvba · May 16th, 2002, 03:20 PM

see current post on removing dup values
I have code in there!

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

May 16th, 2002, 03:18 PM	#1
Chartman of the Bored Board Regular Join Date: Apr 2002 Location: Palo Alto, CA Posts: 75	Hi, I'm trying to set up a spreadsheet that will download data from a web page and refresh each time it's opened, and then delete duplicates. The data is at the link below and is actually a text delimited file located on the web. http://www.nasdaqtrader.com/dynamic/SymDir/mrktsym.txt I've managed to set up a spreadsheet which already does the text-to-columns part and I can refresh by hitting the exclamation (!) refresh button under the "Data" menu. However, there are lots of duplicate rows for the same company (a new row for each location of the company). I need to get rid of the duplicates -- hopefully automatically each time the spreadsheet is opened and refreshed. Thanks in advance for any help.

May 16th, 2002, 03:20 PM	#2
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	see current post on removing dup values I have code in there!