Highlighting Duplicate Values in Column

Help StudioX
,
1

Hello,

How do you highlight duplicate numerical values in a column red using Studio X.

Any guidance is appreciated.

Thanks

2

Hi,

How about the following sample?

image
image911×1444 45.4 KB

NewBlankTask20221220-1.zip (57.2 KB)

Regards,

3

Hello,

Thank you kindly for your response. I am slightly confused on the what the inputs should be since some of the text is cut off. Please see screenshot.

image
image885×744 85.9 KB

Best

4

Hi,

I attached sample files as NewBlankTask20221220-1.zip in my previous post.
Can you check this?

Regards,

5

Hello,

I am unable to open the project. I tried opening it in StudioX/Studio and I get this error.
image

Best

6

Hi,

Which version of StudioX do you use?

If 22.4 or lower, it might not be able to open it.

I’ll share some expressions as text, as the following.(However, as it’s 22.10 style, it might be necessary to modify it for your environment)

To_variable_from_Set_Variable_Value = Save_to_from_Read_Range.AsEnumerable.Select(Function(r) r("Value1").ToString).GroupBy(Function(s) s).Where(Function(g) g.Count>1).SelectMany(Function(g) g).Distinct.ToArray()

Condition

To_variable_from_Set_Variable_Value.Contains(CurrentRow("Value1").ToString)

Regards,

7

I am currently using version 2021.10.5.

Thank you, I will adjust for my version!