A Calc conundrum
I’m wondering if there is a simpler way of doing this
Cell I5 contains a line of text from a bank statement the content will
include or not a key word,
key words are Lidl, SE Gas, Water etc etc
The formula below (in C5) looks at content in cell I5 if the cell contains
one of the key words then a corresponding name is produced in cell C5 ie.
Lidl = Lidl, Water = Water etc etc.
The formula does work, however it is long and is laborious to add new key
words and I’m hoping someone might know a better way of doing it.
New key words would be ‘HOLLAND & BARRETT’ and ‘PAYPAL’ and more as needed.
I’m wondering if its possible to have a list of key words ?
I’ve attached an example – which will make my explanation more clear ? I
",IF(ISNUMBER(FIND("LEGAL & GENERAL",I5)),"LEGAL & GENERAL
W764 LibreOffice 184.108.40.206
View this message in context:
Sent from the Users mailing list archive at Nabble.com.
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
- [libreoffice-users] Calc a formula conundrum · IGraham
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy