Remove Duplicates Range: Cannot remove duplicates in the specified range

Help
1

I have to remove duplicates row from an output excel file with first column is serial number. But the Remove Duplicates Range don’t work or i just didn’t use it in the right way. Can anyone help me with this?
This is the picture of that error and my activity.

image
image1036×563 26.2 KB

1 Like
2

Hi buddy @plmtri.kddi

WELCOME to UiPath community buddy… That’s really a good question to start with

You were almost right buddy, but the ranges should have some alongwith it …like “B1:S14”…like this buddy

1 Like
3

Thank you very much @Palaniyappan , but i have tried “B3:M50” but it still not work, by the way, the excel file’s rows will increase later so i want the range to cover all rows between to 2 column B and M. I have download the Remove Duplicates Range zip file from Uipath website and tried it too, its work on that Example file only but not on my file although i have change the path of the file and the Sheet name too.

image
image980×387 20.2 KB

1 Like
4

Buddy @plmtri.kddi i would like to suggest you with this link given by UiPath…try to find duplicates in this way buddy

Cheers

5

Kindly let know whether this works or not buddy… let’s sort this out…
Cheers

6

Is that working buddy @plmtri.kddi

7

I’m working on it. So please wait me for a while. Thank you @Palaniyappan.

1 Like
8

Dear @Palaniyappan, it worked a little bit, it remove the duplicated rows which are next to each other but not all. Because my robot will run on a long time update website so some of the data from the next time i run will duplicate with the old one already in it, but it not lay next to each other. So i think i must build a activity for this problem on my own. Thank you very much for support me this time buddy.

9

That’s cool…
Buddy you can go for invoke vba activity as well, that could resolve your issue with macros been executed in excel with this invoke vba buddy…lets try that buddy. @plmtri.kddi

10

Oh, good ideal, i will try it, i have never use invoke VBA but i will learn how to use it and try. Thanks a lot buddy. @Palaniyappan

11

Great…let know whether that works buddy… @plmtri.kddi

1 Like
12

Yes, of course. I will tell you if i solved it. @Palaniyappan

1 Like
13

Hi @plmtri.kddi

14

Dear @Palaniyappan, i have remove the duplicates range in my way. Thank you very much buddy. image

2 Likes
15

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.