findAll method - Can't get to row indexes

[Escad199001]

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 the documentation shows e.g. Sheet1!A1 231, Sheet1!A1 300.

I'd like to get to all the row indexes instead if possible, otherwise I need to clean up the returned string.

Would that be possible?

Thank you,

Escad

[#2]

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.

[#3 · Accepted solution]

@Escad199001 

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

[#4]

I ended up doing something similar, so yes you're right!
I was wondering if another pre-defined method existed and I had missed in the documentation.
Good to know! Thanks Sergey.

[#5]

@Escad199001 , you are welcome, glad to help