Archive of Mr Excel Message Board
Back to Data in Excel archive index
Back to archive home
match exact textPosted by mc on January 02, 2002 8:11 AM
let's say i have a column of data that contains stock investments of 20 different companies.i would like to list all stocks w/o duplication.
company 1 Intel
company 2 IBM
The last (appearing in column 3) would show Intel, Microsoft, IBM and Cisco (it would not list IBM twice).
Re: match exact textPosted by Scott on January 02, 2002 8:24 AM
An easy way of doing this is using filter. Select the column of info, then Data-Filter-Advanced Filter. Select "Copy to another location", and then a copy to range. Check "Unique records only" and hit OK.
Re: match exact textPosted by Aladin Akyurek on January 02, 2002 8:25 AM
Do you mean that some entries are all prefixed with
while others consist of the names of the companies?
Re: match exact textPosted by Sam on January 02, 2002 9:21 AM
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.