It should be checked whether the names from column B complete are included in the text of column A. The text sequence can be different z. B. is first the surname and then the first name but actually the name is identical. During the test, only the text parts (individual words) should be compared without special characters, see line 1 - the value "true" should still come out here because the words are actually all in column A.
Column A.
Column B
1
ALDI GMBH & CO.KG
Aldi GmbH + Co. KG
TRUE
2
ALEXANDER BERNS AND CO-OWNER
Alexander Berns
TRUE
3
ALEXANDER KUKSHAUS AND CO-OWNER
Alexander Kukshaus
TRUE
4
JABLONSKI MONIKA
Clement Monica
FALSE
5
MERTIN HELENE SERGEI
Test heather
FALSE
Excel 2010 - Exam: Is complete Text from column B exists in the text from column A.
-
-
"Aldi GmbH + Co. KG" should the "+" not be "&" in column 1?
-
I think he wanted the '+' like that, it should recognize the error and ignore it ...
And I'm just trying out how it works, and as far as I have it now,
does the code run the examples, but still this problem,
if the surname and first name are interchanged. -
So: I was now 1,5 hours busy (and now have to think about something new)
I am currently using Excel 2003 (outta Time: D), which does not take this line away from me,
because it thinks I'm kidding, that's why I outsourced it,but no matter:
That's the finished line running the examples !! BUT !! not all prerequisites met (so don't use it for testing, at least not like that!)
--=WENN(UND(A10<>0;B10<>0);WENN(WENN(ISTFEHL(FINDEN(GROSS(WECHSELN(WECHSELN(WECHSELN(B10;".";);"&";);"+";));GROSS(WECHSELN(WECHSELN(WECHSELN(A10;".";);"&";);"+";))));0;1)>0;"Stimmt";"Stimmt Nicht");"N/A")
If anyone gets further than me, then congratulations, because I'm standing here!
For the sake of convenience, I'll hang the file folder here ...
Download here (3,5kb) -
I got it now. Excel is not well suited for this directly via formulas, since words have to be iterated through. But you could do that with VBA in Excel.
-
-
Yeah, that's why it's only half done, but there should be a function in the 2010s that removes special characters and the like for me.
As I said: I'll get this far, whoever is bored can keep busy.
BTW: What does jofla (the client) say, shouldn't he get in touch?