| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
data 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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
data in a column
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! "ABCD" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search for a column based on the column header and then past data from it to another column in another workbook | Excel Programming | |||
| Macro to paste data to a new column if previous column has data | Excel Programming | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Programming | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| Matching one column against another column of data to show the same amount of data. | Excel Worksheet Functions | |||
Linear Mode
