Is it possible to check 2 values in same IF statment ??
I have an if statment where I check if current row “ID” is same as next row “ID” and upon that result i go true or false…
true = open a website
false = log message = its false.
Now im thinking to check a specifik column have vlaue or not. if it has value then it showed go to next row and if not take that row ID.
ID : Test
2 : ITM123
6 : ITM546
I tried with somethng like…
dtExcel.Rows(RowCount)(“Test”).Tostring = “” And (dtExcel.Rows(RowCount)(“ID”).Tostring <> (dtExcel.Rows(RowCount+1)(“ID”).Tostring))
It’s not giving right answer…
its telling ID is same on next row where ID is not same on row 5 and row 9. So something is not correct the way i did combinination…
The correct answer is open the web page for ID 5 9 8 and not for 1 and 6 which has vlaue.