Go to Jeff Salisbury LWGate Home Page.From: "John Adair" <xjadair@brightok.net>
Subject: RE: [CANSLIM] duplicatein a column
Date: Sat, 15 Dec 2001 21:11:53 -0600
Next Article (by Author): RE: [CANSLIM] Interview "John Adair"
Previous Article (by Author): RE: [CANSLIM] Re:bzh & chbs "John Adair"
Articles sorted by: [Date]
[Author]
[Subject]
Microsoft product support has several ways to perform the function you wish . 1 determine if duplicate values already exist 2 find unique elements in a list 3 finding unique elements in a list http://support.microsoft.com/support query words 4.00a howto list however they just now told me they had no such item but I have a copy of a report fro them showing how There are several very comprehensive web sites which will answer all your excel questions. Don't attempt to learn vb unless you are under 50 years old and have a lot of time to be frusterated. Enter the following information in a ss A1 field name b1 field name c1 field name A2 lori b2 c2 lori A3 frank b3 c3 frank A4 john b4 c4 john A5 frank A6 lori A7 lori In cell b2 enter the formula =(sum((a2=$b$1:b1)*1)=0,a2," ") fill down The unique set of values will be displayed in cells b2:b6 - -----Original Message----- From: owner-canslim@lists.xmission.com [mailto:owner-canslim@lists.xmission.com]On Behalf Of Tangen, Eric Sent: Friday, December 14, 2001 4:37 PM To: 'canslim@lists.xmission.com' Subject: RE: [CANSLIM] Spreadsheet Question You have several options: 1. Write a VBA routine...well worth learning and this is about as good a starter project as it gets. 2. Use Access - (the database program you get with the Professional version of Office)...again, easy if you know database programming. 3. Look into Pivot Tables in Excel...there might be something there. All I know about pivot tables is how to spell it, so this may be a dead end. ERIC TANGEN - -----Original Message----- From: Perry Stanfield [mailto:mpstan@attbi.com] Sent: Friday, December 14, 2001 3:04 PM To: canslim@lists.xmission.com Subject: [CANSLIM] Spreadsheet Question Is there a way to compare two columns of stock symbols in a spreadsheet and determine which symbols are "new" in the second column? This comes up with scans.........It would be nice to automate the process of identifying stocks that are just making a screen for the first time. There must be a way with Excel........... Thanks Perry - - - -To subscribe/unsubscribe, email "majordomo@xmission.com" - -In the email body, write "subscribe canslim" or - -"unsubscribe canslim". Do not use quotes in your email. - - - -To subscribe/unsubscribe, email "majordomo@xmission.com" - -In the email body, write "subscribe canslim" or - -"unsubscribe canslim". Do not use quotes in your email. - - - -To subscribe/unsubscribe, email "majordomo@xmission.com" - -In the email body, write "subscribe canslim" or - -"unsubscribe canslim". Do not use quotes in your email.
Next Article (by Author): RE: [CANSLIM] Interview "John Adair"
Previous Article (by Author): RE: [CANSLIM] Re:bzh & chbs "John Adair"
Articles sorted by: [Date]
[Author]
[Subject]