Problem in building condition

Help Studio
, ,
1

Hello all,

I have an input excel sheet in which in column ‘R’ there is data which I need to check to meet a condition. Once that condition is met, I need to check the value in column B and extract all the rows above or below it if the column B has same value corresponding to column R.

Can anyone help me with this on how to do this? I am new to UiPath and stuck here.

image
image1185×269 6.82 KB

2

@rajat.pushkarna

Use for each row in excel and use if condition inside it to check if column B and column R values are same…if same save the row index or currentindex…then use readrange with the identified row index

Cheers