CODEWITHSUNDEEP
excelexcel-formula
spacecodeur
spacecodeur

Reputation: 2406

Excel formula, find similar string between two columns

I want find a formula who allows to check like this :

column 1 : row 1 : "AAA AA ABB A" ...

column 2 : row 1 : "LLL BBLL" ...

the formula return TRUE with rows 1 of the two columns because there is "BB" I don't want search "BB" but find if two rows are "similare" like this example. Thanks you =)

Is it possible via formula ? (no vb)

Upvotes: 0

Views: 1708

Answers (1)

Axel Richter
Axel Richter

Reputation: 61880

This is maybe possible with the following approach:

enter image description here

This is a German Excel. WAHR=TRUE and FALSCH=FALSE ;-)

Formulas in C4:

{=NOT(AND(ISERROR(FIND(MID($A4,ROW($A$1:INDEX($A:$A,LEN($A4)-$C$2+1)),$C$2),$B4))))}

and in D4:

{=NOT(AND(ISERROR(SEARCH(MID($A4,ROW($A$1:INDEX($A:$A,LEN($A4)-$C$2+1)),$C$2),$B4))))}

These are array formulas. Input them in the cell without the curly brackets and the press [Ctrl]+[Shift]+[Enter] to complete.

The approach is to get an array of $C$2 length substings from string in column A and find/search them in the string in column B.

Upvotes: 0

Related Questions