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.