Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenMon, 07 May 2018 08:31:58 +0200Find text and return row numberhttps://ask.libreoffice.org/en/question/20271/find-text-and-return-row-number/Hi,
In Calc, is there a formula to find a text (like "hello") in a range of cells and return the row number of the first occurrence?
ThanksMon, 15 Jul 2013 16:50:02 +0200https://ask.libreoffice.org/en/question/20271/find-text-and-return-row-number/Comment by Kruno for <p>Hi,
In Calc, is there a formula to find a text (like "hello") in a range of cells and return the row number of the first occurrence?
Thanks</p>
https://ask.libreoffice.org/en/question/20271/find-text-and-return-row-number/?comment=154209#post-id-154209Don't think this should be closed as accepted answer is not quite right. OP wants to search a **range of cells** and get **row of first match** and doubt SEARCH function is doing that. My answer would be to use [**MATCH**](https://help.libreoffice.org/Calc/Spreadsheet_Functions#MATCH) function as it's doing exactly that: `=MATCH("searchFor";B1:B1000;0)`.Mon, 07 May 2018 08:31:58 +0200https://ask.libreoffice.org/en/question/20271/find-text-and-return-row-number/?comment=154209#post-id-154209Answer by Zeki Bildirici for <p>Hi,
In Calc, is there a formula to find a text (like "hello") in a range of cells and return the row number of the first occurrence?
Thanks</p>
https://ask.libreoffice.org/en/question/20271/find-text-and-return-row-number/?answer=20274#post-id-20274Hi,
Are you askling for the SEARCH function? https://help.libreoffice.org/Calc/Text_Functions#SEARCH
Also you may refer to Calc Guide Appendix (B) for Functions:
https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_GuideMon, 15 Jul 2013 19:35:44 +0200https://ask.libreoffice.org/en/question/20271/find-text-and-return-row-number/?answer=20274#post-id-20274Answer by karolus for <p>Hi,
In Calc, is there a formula to find a text (like "hello") in a range of cells and return the row number of the first occurrence?
Thanks</p>
https://ask.libreoffice.org/en/question/20271/find-text-and-return-row-number/?answer=20278#post-id-20278Hi
No, the OP asks for https://help.libreoffice.org/Calc/Spreadsheet_Functions#MATCH
KarolusMon, 15 Jul 2013 20:35:44 +0200https://ask.libreoffice.org/en/question/20271/find-text-and-return-row-number/?answer=20278#post-id-20278