create a separate list for unique records
in [General]
|
Prev: Vlookup with corresponding two data (blank and non blnk)
Next: Custom list limited to 255 characters? (XL 2007)
From: eva cheng on 28 Apr 2010 05:34 I have a column of data with records may duplicate, how can i create a separate list in other area of the worksheet for unique records only, is it possible to do this without macro. Thanks a lot -- eva cheng
From: Bob Phillips on 28 Apr 2010 05:50 Use Data>Filter>Advanced Filter, it has a unique records option. -- HTH Bob "eva cheng" <evacheng(a)discussions.microsoft.com> wrote in message news:A7A58A2C-E566-46A3-8960-E13D661B0E7B(a)microsoft.com... >I have a column of data with records may duplicate, how can i create a > separate list in other area of the worksheet for unique records only, is > it > possible to do this without macro. > > Thanks a lot > -- > eva cheng
From: Malin D on 28 Apr 2010 05:52 If you have Excel 200 or later yes - Choose Insert, Table and Remove duplicates. -- Best regards Malin D Office consultant/Trainer "eva cheng" wrote: > I have a column of data with records may duplicate, how can i create a > separate list in other area of the worksheet for unique records only, is it > possible to do this without macro. > > Thanks a lot > -- > eva cheng
From: ozgrid.com on 28 Apr 2010 05:53
Use advancedfilter for uniques and copy to another location. -- Regards Dave Hawley www.ozgrid.com "eva cheng" <evacheng(a)discussions.microsoft.com> wrote in message news:A7A58A2C-E566-46A3-8960-E13D661B0E7B(a)microsoft.com... >I have a column of data with records may duplicate, how can i create a > separate list in other area of the worksheet for unique records only, is > it > possible to do this without macro. > > Thanks a lot > -- > eva cheng |