Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
WorkingWithText
 
Posts: n/a
Default comparing columns of text (cross-searching)

I am trying to figure out a quick way to compare two columns of text for
common phrases. The two columns - one of which has over 30k rows - have cells
with company names. I simply need to identify the companies that are listed
in both columns. However, because the same company may be written with slight
textual differences in either column (i.e. "3M" versus "3-M"), I need to
search based on the proximity of characters to each other (i.e. "3" and "M,"
in that order, within a couple of characters of each other). Ideally, I would
also like tally of the number of instances of overlap (one column has no
duplication of company names while the other has extensive duplication -
although, again, even within a single column the same company may be listed
under several different variations in spelling).

I would greatly appreciate any guidance! Thank you.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
TEXT TO COLUMNS WITH LEADING ZEROS Peggy Excel Discussion (Misc queries) 6 April 27th 23 03:45 AM
Comparing Two Columns of Text sailortigger Excel Discussion (Misc queries) 2 June 21st 05 08:11 PM
Text to Columns from drop down list update Kurgan Excel Discussion (Misc queries) 0 June 21st 05 12:14 PM
Text to Columns in excel for delimited files - allow trimming opt. D. Young New Users to Excel 1 April 25th 05 05:06 PM
text from one column into multiple columns Jeff Brown Excel Discussion (Misc queries) 6 December 22nd 04 11:07 PM


All times are GMT +1. The time now is 05:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"