Apache OpenOffice Community Forum

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 ;]

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.

formula will be better ;]

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 "\>".