What is an op-ed column?

Excel?? Some duplicate word in column sorting remedy

• I trade the stock market..I use a charting systen that i can load hundreds of stock symbols into(for reveiwing my charts)...in column form.(single column) Here's what I need and why. There is a need for me to add and delete stock symbols weekly.I can go to websites that post the most active, the weekly highs, lows etc.. I can copy and paste these lists of stock symbols into my charting column..The problem is, I am loading hundreds of new symbols at a time (sometimes 300-400 additional symbols).And there is no way to detect duplicate symbols until I load into this charting column. At times I have upwards of 1500 symbols loaded. After loading into column,I have to manually go the entire column and delete the dupicates, triplicates sometimes quads (the symbols will post in column as pairs etc in my chart column)..This is very time consuming..It takes approx 2-4 hrs to do depending on the number of duplicates..If ther are trips and quads it takes forever.. Is there a program that i can copy and paste my existing symbols to in column form, and then copy and paste other lists of symbols onto the same worksheet, and they will sort and only post the new data (symbols).. My inexperienced theory and dream would be.. Go thru my existing column of symbols and delete the dogs.. Open spreadsheet / worksheet.. Paste my existing symbols into a workspace column..300-800 symbols Copy and paste new symbols into another column or same column (adding at the bottom)... Clik the ascending option and the symbols sort alphabetically and delete duplicates.. Then simply copy and paste from this worksheet into my stock chart columns.. I would sure appreciate some help with this, as i said, it is very time consuming and boring...It's also kinda hard on my wrists having to click the up and down keys and hit delete key for hours.. Thank you..

• Answer:

  benbowpro... If I understand your query correctly, there is such a utility, created by Jacob Hilderbrand, a true geek and VBA master who created this amongst a variety of what are called macros in Excel. His portfolio of macros is here: http://vbaexpress.com/forum/member.php?u=135 The delete duplicates function you are seeking is on this page: http://www.vbaexpress.com/kb/getarticle.php?kb_id=135 I just tried it out, creating columns of numbers and letters. I tried it first on one column, and it handily deleted all but unique entries. I tried it on two columns at a time, and it handily deleted all but unique entries in *each* column, independently of the other, so that column A might still contain entries found also in column B, but each column only listed each unique entry once. To use this, don't bother with the code on that page. Simply download the DeleteDups.zip file from the bottom of the page, and this will serve as a template Excel page which already has the Macro built in, and into which you can post your data. Then, based on the description you offered, copy and paste the "dog"-free list into column A, followed by pasting the list of new entries beneath it. Sort or don't, but you can then highlight the entire column, either by highlighting all the entries, or by simply clicking on the A at the top of the column. After highlighting, go to the menu bar up top and click on Tools -> Macro -> Macros, highlight the DeleteDups macro, and click on Run. This will quickly eliminate all but unique entries in column A. You can sort after deleting all the duplicates, as easily as sorting beforehand. You can then either copy and paste that data to a separate sheet, and close the original DeleteDups.xls file without saving changes, so as to preserve the original template, or you can click on Save As (not just Save, which will permanently save your data under the template filename!) from the File menu, and give the sorted version a new name, which will also preserve the original template with its original name, empty of data. I believe this will do exactly what you've requested, but if it doesn't succeed in turning a 4-hour wrist torture into a 1-minute joy, do let me know what's not working as it should. Please do not rate this answer until you are satisfied that the answer cannot be improved upon by way of a dialog established through the "Request for Clarification" process. A user's guide on this topic is on skermit-ga's site, here: http://www.christopherwu.net/google_answers/answer_guide.html#how_clarify sublime1-ga Additional information may be found from an exploration of the links resulting from the Google searches outlined below. Productive searches done, via Google: excel "delete duplicates in a column" ://www.google.com/search?q=excel+%22delete+duplicates+in+a+column%22