 |
 | 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 / Programming / September 2007data in a column
I have data in an excel spreadsheet. In one column, I have repeatative entries. For example, the column looks like aaaa bbbb aabb aaaa bbbb etc. The problem is that the column has some 20000 rows, and I need to find these type of entries that are repeating again and again. For example in the above case, what I am looking for is "aaaa, bbbb, aabb" that is all. In my real example, I might have some 40 or 50 such different entries. It will take me hours to go thru the column and find those. Plus manual error will be unavoidable. I would suggest using the Chip Pearson methodology for extracting unique entries from a list (which he refers to as 'Listing Distinct Elements In A List.') I've used it before and it works like a charm!! http://www.cpearson.com/excel/ListFunctions.aspx Good luck! > I have data in an excel spreadsheet. In one column, I have repeatative > entries. For example, the column looks like [quoted text clipped - 13 lines] > hours to go thru the column and find those. Plus manual error will be > unavoidable. |
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.