partial text match character count

garethx

New Member
Joined
Nov 28, 2005
Messages
3
Hi All,

I am hoping that some of you may be able to share some wisdom with me. I have been struggling with this for a while with no joy.

Can excel flag two cell that are similair? ie. A1 = excelmadnes5 & A2 = excelmodnes2.... in these two cells there are two character differences. is there a condition or IF statement that can be used to flag two cells as simililair if no more than 2 characters are deffirent in each cell? I am trying to compare two columns from two seperate sources of data entry with a large margins for keystroke errors.
the cells would contain customer names and would be varied from customer to customer..

Any help with this would be hugely appreciated!!! :-D

Many thanks for your help!!
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
You could use this formula in C2 to compare A2 and B2, then copy down column as needed

=IF(A2<>"",IF((SUMPRODUCT(--(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)<>MID(B2,ROW(INDIRECT("1:"&LEN(A2))),1)))<3),"similar","different"),"")

Note: the above is not case-sensitive

PS....Welcome to the board 8-)
 
Upvote 0
That works a treat!!

many thanks Barry! thats exactly what i was looking for.

great forum, will definately be hanging around for a while :)

Thanks Again
g
 
Upvote 0
silly question maybe, but will this work in access (replacing the cell reference with the access field reference and change IF to IIF, ?

Thanks again,
 
Upvote 0

Forum statistics

Threads
1,226,390
Messages
6,190,738
Members
453,616
Latest member
nathancook

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top