Search similar cell.

Discuss the spreadsheet application
Post Reply
dawidek990
Posts: 55
Joined: Thu Dec 13, 2018 10:27 am

Search similar cell.

Post 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 ;]
OpenOffice 4.1.6 Windows 10
User avatar
RusselB
Moderator
Posts: 6646
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Search similar cell.

Post 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.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
dawidek990
Posts: 55
Joined: Thu Dec 13, 2018 10:27 am

Re: Search similar cell.

Post by dawidek990 »

formula will be better ;]
OpenOffice 4.1.6 Windows 10
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Search similar cell.

Post 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 "\>".
Attachments
similarity.ods
(16.01 KiB) Downloaded 67 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply