 |
 | 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 / New Users / September 2006Deleting Duplicate Numbers In A Column: How ?
Hello, Have a long list of numbers, formatted the same, in a column. Would like to delete duplicate numbers. How can I do this, please ? Thanks, Bob Is this the only data in your sheet? If so, then enter a heading in A1 if you don't already have one (insert a new row 1 if necessary). Then highlight all the data including the heading and click Data | Filter | Advanced Filter - here you can specify to filter in place and to have Unique Records only, and then click OK. Hope this helps. Pete > Hello, > [quoted text clipped - 6 lines] > Thanks, > Bob
|
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.