Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenMon, 11 Apr 2016 20:40:18 +0200Find a word and move it... [solved]https://ask.libreoffice.org/en/question/68072/find-a-word-and-move-it-solved/ Is there a way to find a single word and move it to another column, in Calc? For example, I have a column that contains first and last names, separated by a comma. Not a problem finding the comma or the name, after, but I need to move the last name to another column. talkinggoatMon, 11 Apr 2016 20:40:18 +0200https://ask.libreoffice.org/en/question/68072/How to find a non-sequence match between rows?https://ask.libreoffice.org/en/question/22007/how-to-find-a-non-sequence-match-between-rows/Hi!
I'm a newbie, no experience with excel or any other office tools. Sorry if I labeled the question in a wrong way
I need a function to find matches between two rows.
Lets say I have populated a column with each row containing numbers:
A1: 9 20 53 60 90 40
A2: 5 20 30 45 60 80
AN: ........
So for example - in B1 i write: 60 5 30 80
The function should return a match in A2
Thanks!
snakeat3rFri, 30 Aug 2013 14:27:15 +0200https://ask.libreoffice.org/en/question/22007/