sorting
 

I have a set of stock symbols I download every day based on a screening
program. The next days run will contain most of the previous days list plus
some new ones. There are about 100 each day. Is there a way I can sort the
next days list to include only the symbols that are new for that day, ie,
not on the previous days list?

I have made some macros before but I have not figured out a formula to do
this.

Thanks,

Doug

Chip Pearson has information on finding and tagging duplicate entries in
a list.

http://www.cpearson.com/excel/duplicat.htm

You could import the list, tag the symbols that are in the previous
day's list, and copy the untagged symbols to a different area of the
worksheet.


ddh wrote:
I have a set of stock symbols I download every day based on a screening
program. The next days run will contain most of the previous days list plus
some new ones. There are about 100 each day. Is there a way I can sort the
next days list to include only the symbols that are new for that day, ie,
not on the previous days list?

I have made some macros before but I have not figured out a formula to do
this.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanks,

This guy has some great resources for Excel and VBA on his site.

Doug

"Debra Dalgleish" wrote in message
...
Chip Pearson has information on finding and tagging duplicate entries in
a list.

http://www.cpearson.com/excel/duplicat.htm

You could import the list, tag the symbols that are in the previous
day's list, and copy the untagged symbols to a different area of the
worksheet.