Search similar cell.

Discuss the spreadsheet application

Search similar cell.

Postby dawidek990 » Sat Jan 12, 2019 11:27 pm

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
dawidek990
 
Posts: 52
Joined: Thu Dec 13, 2018 10:27 am

Re: Search similar cell.

Postby RusselB » Sun Jan 13, 2019 12:07 am

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 and LibreOffice 6.3.3.2 on Windows 7 Pro & Ultimate
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.
User avatar
RusselB
Moderator
 
Posts: 5702
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Search similar cell.

Postby dawidek990 » Sun Jan 13, 2019 2:47 pm

formula will be better ;]
OpenOffice 4.1.6 Windows 10
dawidek990
 
Posts: 52
Joined: Thu Dec 13, 2018 10:27 am

Re: Search similar cell.

Postby Villeroy » Sun Jan 13, 2019 4:00 pm

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 12 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27393
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: No registered users and 16 guests