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 ;]
User community support forum for Apache OpenOffice, LibreOffice and all the OpenOffice.org derivatives
Search similar cell.
4 posts
• Page 1 of 1
Re: Search similar cell.
by 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.
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.
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.
-
RusselB - Moderator
- Posts: 5987
- Joined: Fri Jan 03, 2014 7:31 am
- Location: Sarnia, ON
Re: Search similar cell.
by dawidek990 » Sun Jan 13, 2019 2:47 pm
formula will be better ;]
OpenOffice 4.1.6 Windows 10
- dawidek990
- Posts: 55
- Joined: Thu Dec 13, 2018 10:27 am
Re: Search similar cell.
by 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 "\>".
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.4
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
-
Villeroy - Volunteer
- Posts: 28230
- Joined: Mon Oct 08, 2007 1:35 am
- Location: Germany
4 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 17 guests
|
Forum powered by phpBB © phpBB Group
By any use of this Website, you agree to be bound by these Policies and Terms of Use |
Get OpenOffice
|