Form excel , i want to get Last Cell position of a string in that column

Help Studio
, , ,
1

Hi ,

I want to get the starting and Ending(last) cell position(integer number) of the of the value that i’m searching in that column.

image

By using lookup range when i search for text “Sri” i get cell position as 1

but as per my requriement. I want the last cell position matching to “Sri” i.e 6.

Can anyone suggest me, how can i get the last cell position of requried text

Regards,
Srikanth

2

@srikanthmadireddy78
find some starter help here, showcasing First, Last All Index retrieval:
FindIndex_FirstLastAllMatch_1Col_1Val.xaml (8.7 KB)

3

Hi @srikanthmadireddy78,

Here is an activity called “Find”. it will return the cell info and row index as an array. So the last element is the last index.

Regards
Balamurugan.S