Actually my exact scenario is…
Have to read the column E First cell value (i.e., E2) and based on that E2 value, need to get A2, B2, C2, D2, F2, G2, H2, I2.
After this, have to read E3 and if E2 cell value is equal to E3 cell value, then need to get only H3 & I3.
If E2 is not equal to E3 then have to read A3,B3,C3,D3,F3,G3,H3,I3. then next have to read E4 and remaining follow is same thing as above.
As of now, i have completed as below.
Step 1.Using Read range activity - stored the sheet ‘CIDF’ as outDt
Step 2.For Each Row activity- reading the Column E (row(4).ToString)
Next waiting for your suggestion for below steps
Step 3.once read the Column E2 cell value, have to find the cell position and based on this cell position, have to get next cell values (A,B,C,D,F,G,H,I) and store in variable…
Step 4.Next, have to read E3, if E3 and E2 are equal, then have to get H3, I3 values and store in variable. If E3 & E2 not equal then it should do like step 3. then E4 then E5, E6… like this in loop. it should go on. attaching the excel & workflow Book1.xlsx (10.4 KB) dummy.xaml (7.3 KB)