For a tutorial video on 'index' and 'match' see "LibreOffice Calc -
Index and Match": https://www.youtube.com/watch?v=8zydk03ILXs
On 11/4/2016 2:48 PM, Paul D. Mirowsky wrote:
The formula does work, however it is long and is laborious to add
new key
words and I’m hoping someone might know
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 ?
This may help wit
Hello
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