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 keywords 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 with your key-word-list. MATCHReturns the relative position of an item in an array that matches a specified value. The function returns the position of the value found in the lookup_array as a number.Syntax |MATCH(SearchCriterion; LookupArray; Type)||Find more information at: https://help.libreoffice.org/Calc/Spreadsheet_Functions#VLOOKUP|I’ve attached an example – which will make my explanation more clear ? I hope ----- IGraham W764 LibreOffice 188.8.131.52 --View this message in context: http://nabble.documentfoundation.org/Calc-a-formula-conundrum-tp4199203.htmlSent from the Users mailing list archive at Nabble.com.
-- To unsubscribe e-mail to: firstname.lastname@example.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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