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.
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