Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help eliminating text duplicates!
I need some major help.
I have a spreadsheet with around 28000 rows. In Columns C and D, there are two different lists. Each column has text that should match. For example in Column C it might say "sprockets," and in Column D it would say "Sprockets and Space Company." Then another row might say "engines," yet in Column D it would say the same "Sprockets and Space Company." I want to eliminate the rows that would obviously not match up like the latter example, and keep the ones that would match up just like the former. Is there something I can do? The first 5 or 6 characters should match up. Thanks for your help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help eliminating text duplicates!
potencially
enter helper column E in E1 enter =if(left(C1,4)=Left(D1,4),"",1) copy and paste down to the end of your data select column E <data<filter<autofilter in the arrow box in E1 select 1 selact all of the 1s and <edit<delete row "Excelhelp" wrote: I need some major help. I have a spreadsheet with around 28000 rows. In Columns C and D, there are two different lists. Each column has text that should match. For example in Column C it might say "sprockets," and in Column D it would say "Sprockets and Space Company." Then another row might say "engines," yet in Column D it would say the same "Sprockets and Space Company." I want to eliminate the rows that would obviously not match up like the latter example, and keep the ones that would match up just like the former. Is there something I can do? The first 5 or 6 characters should match up. Thanks for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
is it possible to combine data sets, eliminating duplicates? | Excel Worksheet Functions | |||
Find date duplicates Col 2 or Col 3 then combine Col 1 text | Excel Worksheet Functions | |||
parse comma separated text to multiple cells and remove duplicates | Excel Worksheet Functions | |||
Eliminating #N/A | Excel Worksheet Functions | |||
Counting Repeated text or duplicates in a list | Excel Discussion (Misc queries) |