Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Sorting Spreadsheet with Merged Fields | Excel Discussion (Misc queries) | |||
Question on sorting dates | Excel Discussion (Misc queries) | |||
Sorting problem | Excel Discussion (Misc queries) | |||
sorting question | Excel Discussion (Misc queries) |