How to compare two excel sheets and mark "Duplicate" in the remarks column of Sheet 2?

Hello All,

I have two excel sheets. I want to compare two columns in each sheets and remark as “DUPLICATE” if found a duplicate.

Please refer the attached excel.

New Microsoft Excel Worksheet.xlsx (9.4 KB)

Hi @jijorhohim98 ,

use below mentioned workflow

If(dt.Select(“[PV Number]=”+CurrentRow(“PV Number”).ToString+“”).Count>1,“DUPLICATE”,Nothing)


Hi @jijorhohim98,

check attached Xaml

Sequence3.xaml (8.5 KB)

Hi Rajkumar,

Thanks for responding back.

Since I’m using older version of studio, I couldn’t find this activity. Is there a package which has this activity ?

Says the document is invalid

Hi @jijorhohim98,

install below mentioned package