Highlights duplicates in same column in same Excel

Help Studio
, ,
1

Hi,
Could you please help with the below requirement with Uipath workflow?
I’m new to the Uipath

I want to highlights duplicates in column A & C
have attached images for the example input and output

InputInput
OutputOutput

Thank You

2

hi, welcome to the forum

3

Hi,
First, let’s get repetitive values only to array of string
arr = (From row In dt
Group row By k=row("ColName").ToString.Trim Into grp=Group
Where grp.Count >1
Select r = grp(0)("ColName").ToString).ToArray

Second, let’s find indexes of rows in dt , that should be colored (also array of string)
rows_to_color = (From row In dt
Where Array.IndexOf(arr, row("ColName").ToString) > -1
Select val = dt.Rows.IndexOf(row).ToString).ToArray

Than use Set Range Color activity :grinning:
Main.xaml (8.9 KB)

1 Like
4

Thank you so much :orange_heart:

5

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