Excel Help Needed

M

markc

I want to place stock symbols from several spreadsheets into one spreadsheet. For example, I have a file with fast growing eps, another with fast growing sales, another with low p/e etc etc.

Copying each of these into one column in one spreadsheet only takes a couple of minutes. The trouble is I end up with duplicate ticker codes where a stock might be in the list for fast growing eps and fast growing sales.

I have just manually gone through my list and deleted the duplicates and it took some time. I reduced my original list down from just over 1000 to 650.

My question is can I remove the duplicate entries some other way?

Mark
 
Can anyone offer a suggestion on how I can prevent a function call error in VB.net when trying to fetch Excel values? Sometimes a cell in XL is in edit mode so when my vb timer tries to fetch a cell it aborts.
 
Quote from markc:

I want to place stock symbols from several spreadsheets into one spreadsheet. For example, I have a file with fast growing eps, another with fast growing sales, another with low p/e etc etc.

Copying each of these into one column in one spreadsheet only takes a couple of minutes. The trouble is I end up with duplicate ticker codes where a stock might be in the list for fast growing eps and fast growing sales.

I have just manually gone through my list and deleted the duplicates and it took some time. I reduced my original list down from just over 1000 to 650.

My question is can I remove the duplicate entries some other way?

Mark
More...

Install ASAP Utilities. It's an add on for Excel with over 300 additional functions. Works very well for your problem. and the programm is for free.

http://www.asap-utilities.com/
 
You must log in or register to reply here.
Back
Top