How to group all duplicates using excel sort range in Uipath modern design

Help Studio
, ,
1

Hi, I am trying to group all duplicates using sort range activity ,
Signature column consist 40021 with blue color and 50021 doesnt have the blue color…and both have the duplicates …I am trying to group them togather as
Input:

image
image1513×840 86.7 KB

InputData.xlsx (81.4 KB)

and after sorting it will look like
output:

image
image483×727 29.7 KB

2

Hi @Syed_Sultan_Ahmed1

image
image873×940 43.9 KB

image
image1169×658 35.5 KB

Output

image
image744×668 31.9 KB

If you still not getting the required output,Please try to downgrade the UiPath.Excel.Activities dependency by making runtime rule as lowest applicable in the manage Packages.

Hope it helps!!

3

@Syed_Sultan_Ahmed1

image
image933×806 33.5 KB

Output:
image
image539×642 28.4 KB

Actually it is working fine please check once,

You are getting the highlighted once because those contains alphabets so that rows coming first.

4

Thanks its working …

1 Like
5

Hi the solution is not working , Please help me with this
SortInputData.xlsx (99.2 KB)
with this input file

  1. I need to filter column SIGNATURE and select only 40021 and color them with light blue.
  2. Then I need to clear all filter
  3. then group all duplicates by using sort range…this not working
    when the bot changes the colur of the data then grouping of duplicates are not working.
6

I tried simple steps but after coluring it…its not working
sortingData.1.0.1.zip (85.7 KB)