Hi
I have number of column in Excel such as,
S.No Name Rank Status
-
Sam 2 Pass - it will be given by me
-
Sam 2 ------- output will be "Pass" compare by this row and above row is equal
-
Ram 1 ------- Outpt will be "Fail" comparing by this row and above row is unequal.
in above it need to check row(“Name”) of previous index and current index will be equal need to write row(“Status”) is Pass as above row .
If it will be failed need to update by fail.
Regards,
@Spark_robot