Compare columns in two worksheets for similar text

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Compare columns in two worksheets for similar text

06-12-2022, 09:26 AM

Logit

Windows 10 Compare columns in two worksheets for similar text

Office 2007

Expert

Join Date: Jan 2017

Posts: 591

The following assumes your posted macro works successfully.
:
On the Second Sheet in a BLANK COLUMN, enter the following formula on ROW #3 :

Code:

=RIGHT(B3,LEN(B3)-SEARCH(" ",B3))&", "&LEFT(B3,SEARCH(" ",B3)-1)

Now drag that formula down the column as far as there is data in Col B.

Next, edit your macro to compare against Sheet 2, Col B.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to compare two csv files mainly two columns containing time	rupeshforu3	Excel	2	07-11-2017 09:03 PM
How to compare two columns and match data	Neydo222	Excel	2	09-12-2015 02:49 AM
Need help with a VLOOKUP formula & two similar, yet non-identical columns of data.	mikey386	Excel	1	12-18-2014 01:59 AM
Need To Compare Two Worksheets, Update Current Records And Insert New	David92595	Excel	1	07-20-2012 07:00 AM
How to compare 2 columns with other two columns in EXECL 2007?	Learner7	Excel	5	06-12-2010 09:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:23 AM.