I need to compare 2 cell and paste result in another cell

image

  1. Use Read Range activity to load data into datatable
  2. Use For Each Row activity to iterate through datatable rows
  3. Execute the test for row fields that corresponds to B and C columns
  4. Update the field that corresponds to D column with the test results
  5. Use Write Range activity to paste the datatable back to Excel

Hi @pradeep_kumar_gouda ,
With in the for each row
Using if condition try this condition and check the syntax once

Row.item(“columnName1”).equals(row.item(“columnName2”))
If it is equal assign row.item(“comments”) = pass else row.item(“comments”) = fail

Use get row item in for each loop and compare the results in if condition if its true write pass else fail

NOT WORKING BRO… PLS CHK MY ACTIVITY.

compare2Cell.xaml (9.7 KB) YourExcelFilePath.xlsx (9.3 KB)

check this out, hope this works

not working bro.

Share your input file. I have included both Excel sheet and also code… works perfectly