match exact text
Posted 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.
example:
company 1 Intel
Microsoft
IBM
company 2 IBM
Cisco
The last (appearing in column 3) would show Intel, Microsoft, IBM and Cisco (it would not list IBM twice).
thanks
Posted 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.
Posted by Aladin Akyurek on January 02, 2002 8:25 AM
Do you mean that some entries are all prefixed with
company N
while others consist of the names of the companies?
Aladin
=====
Posted by Sam on January 02, 2002 9:21 AM
