Page 1 of 1

Search similar cell.

PostPosted: Sat Jan 12, 2019 11:27 pm
by dawidek990
Hi ;]
I need a formula.
I have in cell A1: DEKOR ODEON 3D BLACK 25x90
in column B somewhere is: DEKOR ODEON BLACK 3D 25x90
ew: ODEON 3D BLACK DEKOR 25x90
The point is that the name is the same but the order of the words is changed, what to do to calc find it as true?
greetings ;]

Re: Search similar cell.

PostPosted: Sun Jan 13, 2019 12:07 am
by RusselB
If you're looking for a formula, then I think you'll be needing something with regex (regular expressions)... I'm still learning about them myself.
If you just want something that will give you a quick viewing, then you might try using the Similarity switch in the More Options section of the Find & Replace dialog.

Re: Search similar cell.

PostPosted: Sun Jan 13, 2019 2:47 pm
by dawidek990
formula will be better ;]

Re: Search similar cell.

PostPosted: Sun Jan 13, 2019 4:00 pm
by Villeroy
Turn on regular expressions in formulas.
The example counts the occurrence of max. 4 words entered in the first row by means of word boundaries "\<" and "\>".