Read Excel Cell Dynamically and Compare with the Immediate Cell

image
I want to read each cell value dynamically and compare with the immediate next one, if the value matches then it will continue checking else it will consider the new value as base and start doing the same procedure.

Thanks

Hi @Tanzill_Ahsan

please look at the solution attached.

ReadCellvalueWithImmediateNext.xaml (11.9 KB)

Regards
loveleet Saini

@loveleet_Saini can you please provide me your test excel file?