[libreoffice-users] Re: Calc a formula conundrum

First, apology for the late reply Second a thought directed at me by me 'be careful what you wish for' Third, thanks Rémy Rémy your understanding of spreadsheets is obviously a great deal deeper than mine, your solution does what i want. :) i just have to work out what its doing now, I've never

[libreoffice-users] Re: Calc a formula conundrum

Hello, The easiest would be to use VLOOKUP() with maybe some massaging of the statement messages. I have updated your file with two examples (columns E and F of Sheet1). In my opinion, this would be the easiest way to support multiple additions with a minimum of headaches. BANK_STATEMENT.ods

[libreoffice-users] Re: Calc a formula conundrum

Thank, a couple of things to experiment with, but thats going to have to wait till tomorrow, i shall report results eventually - IGraham W1064 LibreOffice 5.1.6.2 -- View this message in context: http://nabble.documentfoundation.org/Calc-a-formula-conundrum-tp4199203p4199232.html Sent f

[libreoffice-users] Re: Calc a formula conundrum

IGraham wrote > I’m wondering if there is a simpler way of doing this Use the function FIND to locate the word TO and then get all text after it (100 characters should be enough...) =MID(I5;FIND("TO";I5)+3;100) -- View this message in context: http://nabble.documentfoundation.org/Calc-a-formu

[libreoffice-users] Re: Calc a formula conundrum

BANK_STATEMENT.ods the attachment didn't seem to upload so trying again - IGraham W764 LibreOffice 4.4.2.2 -- View this message in context: http://nabble.documentfoundation.org/Calc-a-formula-conundrum-tp4199203p4