Ask Your Question
0

Find text and return row number [closed]

asked 2013-07-15 16:50:02 +0200

CMKT gravatar image

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

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-03 23:17:09.143071

Comments

Don'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 function as it's doing exactly that: =MATCH("searchFor";B1:B1000;0).

Kruno gravatar imageKruno ( 2018-05-07 08:31:58 +0200 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2013-07-15 19:35:44 +0200

Zeki Bildirici gravatar image

Hi,

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_Guide

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2013-07-15 16:50:02 +0200

Seen: 5,190 times

Last updated: Jul 15 '13