Hello all, I compare 6 same characters but need to exclude 1 case: 010106 & 010107 (not different). How can i do that Left(RowPhu.Item(1).ToString,6)=Left(DtPhu.Rows(idx+1).Item(1).ToString,6)

((Left(RowPhu.Item(1).ToString,6)="010106" or Left(RowPhu.Item(1).ToString,6)="010107") and (Left(DtPhu.Rows(idx+1).Item(1).ToString,6) = "010106") or Left(DtPhu.Rows(idx+1).Item(1).ToString,6) = "010107")) Or Left(RowPhu.Item(1).ToString,6)=Left(DtPhu.Rows(idx+1).Item(1).ToString,6)

Compare rows but need exclude 010106 & 010107

Help Studio

Gokul001 (Gokul Balaji) August 23, 2022, 8:09am 2

Hi @anh.nguyen

How about this expression?

Use If activity

Currentrow("Column Name").Tostring.Equals("010106") or Currentrow("Column Name").Tostring.Equals("010107")

Regards
Gokul

2 Likes

Forum Engagement Daily Reports

Topic		Replies	Views
Comparing two excel column Help excel , activities	4	1165	April 24, 2018
Loop for compare current row & next row1, row1 & row2, row2 & row3.... last row Studio	10	1054	August 24, 2022
Compare rows from different Excel Help excel , activities , studio	6	1253	October 31, 2018
HOW compare two columns in excel Activities excel , activities , studio	24	1992	August 17, 2022
Compare first X caracters of rows after if condition Studio studio , question , activities_panel	7	300	May 30, 2023

Most Active Users - Yesterday
ashokkarale
Anil_G
Yoichi
yangyq10
postwick
chandreshsinh.jadeja
aravindbalineni123
Parvathy
aya
PRASHANT_GABHANE
More details...

Compare rows but need exclude 010106 & 010107

Related Topics