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

Help Activities
, ,
#1

image

#2
  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
#3

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

#4

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

#5

NOT WORKING BRO… PLS CHK MY ACTIVITY.

image
image1186×741 21.1 KB

#6

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

check this out, hope this works

#7

not working bro.

#8

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