 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / October 2006Unique list of entries
I have a column of texts. Some of cells are repeated. I want to obtain unique column of texts. How can I obtain it. Data I have: aaa bbb ccc aaa ddd bbb I want to obtain: ( In a separate column) aaa bbb ccc ddd One method is to use Advanced Filter - Select the range including the header row, Data-Filter-Advanced Filter, choose copy to another location, check unique records only and enterthe destination cell where it asks where you want to copy to.  SignatureKevin Vaughn > I have a column of texts. Some of cells are repeated. I want to obtain > unique column of texts. How can I obtain it. [quoted text clipped - 14 lines] > ccc > ddd |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.