Get the row number of starting cell and ending cell of a certain type of Value in an excel?

AryanSingh · February 28, 2020, 8:42am

Hello Guys.

I am trying to find the range of a certain type of data in a excel sheet. Example screenshot is given below after the description.

the secon column is named “Center”. There are different type of center, I am trying to select the range where it lies.

Can anyone help me?

Thanks
Aryan

ppr · February 28, 2020, 8:56am

@AryanSingh
can you please upload the sample data EXCEL. On this base I could create a demo for you

AryanSingh · February 28, 2020, 8:57am

Ok. Wait. I will do that.

Thanks
Aryan

Topic		Replies	Views
How to get the row number of starting cell and ending cell of a certain type of Value in an excel? Activities excel , activities , question	5	990	March 2, 2020
Find Range of cell using column Name Help datatable , excel , activities , string , question	12	4351	June 24, 2020
Finding a range Studio	2	1059	February 18, 2020
Select until the end of a column starting from a specific cell Help excel	7	3164	October 23, 2019
Identifying end range in Excel Help	11	5076	October 14, 2019