Forum Discussion
Solved
findAll method - Can't get to row indexes
Hi Everyone, I need to manipulate a few strings in my spreadsheet.For that, I'm using the findAll and getAddress() methods. The getAddress returns a string with all the matches just like what th...
There are no other options for getAddress(). Options are to transform returned text by script or outside; or return row indexes by other way.
findAll() returns set of areas, for each are you may related to this area range properties. For such example
Output is
findAll and getAddress are not standard Excel functions. From what you are describing, however, FILTER(ROW(all_items);some_condition) might get you what you want. Also, if getAddress literally returns what you show, you could also try =INDEX(TEXTSPLIT(some_address," "),1,2)*1.