Hi!
Is it somehow possible to replace ABCDEFGH in formula: FÖRSKJUTA('MATERIAL LISTA'.$K$95;VÄLJ(HITTA($C$13;"ABCDEFGH");0;27;54;78;90;111;147;166);0;VÄLJ(HITTA($C$13;"ABCDEFGH");26;26;23;11;20;35;18;14);1)
With:
ROSTFRITT
STÅL
ALUMINIUM
BRONS
MÄSSING
KOPPAR
TITAN
PLAST
[Solved] Replace reference letters with words in drop list
-
- Posts: 12
- Joined: Fri Mar 29, 2019 9:51 am
[Solved] Replace reference letters with words in drop list
- Attachments
-
- Text in drop list example 1.ods
- (36.19 KiB) Downloaded 71 times
Last edited by Hagar Delest on Fri Apr 12, 2019 8:49 pm, edited 1 time in total.
Reason: tagged solved
Reason: tagged solved
Apache openoffice 4.1.1
Windows 10
Windows 10
-
- Posts: 12
- Joined: Fri Mar 29, 2019 9:51 am
Re: Replace reference letters with words in drop list.
HI!
Thanks!
Unfortunately, I can't get it work.
Do you have ability to help me with this?
B/R
Thanks!
Unfortunately, I can't get it work.
Do you have ability to help me with this?
B/R
Apache openoffice 4.1.1
Windows 10
Windows 10
Re: Replace reference letters with words in drop list.
Post your code, please.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: Replace reference letters with words in drop list.
Or upload a sample spreadsheet - not an image - with sample data and examples of what you have unsuccessfully tried.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
Re: Replace reference letters with words in drop list.
Hi,
with two additional columns ...
with two additional columns ...
- Attachments
-
- Text in drop list example 1.ods
- (53.3 KiB) Downloaded 76 times
LibreOffice 5.4, 7.0, 7.2 on LinuxMint/Win10
-
- Posts: 12
- Joined: Fri Mar 29, 2019 9:51 am
Re: Replace reference letters with words in drop list.
Thanks! Mikele
Thats a nice solution.
Thats a nice solution.
Apache openoffice 4.1.1
Windows 10
Windows 10