Remove Duplicates Range(EXCEL) does not working correctly

Help
1

Installer(.exe or .msi):EXE

License type(Free, Trial/License code):Enterprise

Studio/Robot version:2018.4.2

Current behavior:

Screenshot:

I want to remove the duplicate value of Column ‘G’ using ‘Remove Duplicates Range’ of EXCEL ACTIVITIES.
The range is set to ‘G1’, but the result is only the first row and is deleted. It is presumed to be deleted based on the column ‘A’.
I do not know whether it is wrong or not.
I do not want to do this using DATA TABLE.

image
image1823×1004 400 KB

2

Hi @joonhyunghong

Check this

Remove Duplicates Range: Cannot remove duplicates in the specified range

Thanks
Ashwin.S