Count the type of letter

[Edd_0820 (Eddie_wan)]

Hi all

Below list contain several letter

but letter is duplicate

how can i count the number of letter without duplicate

as below result is 7

[aanandsanraj (Anandraj Rajendran)]

Hi @Edd_0820,

• Read the excel using excel activity
• Use Remove Duplicate Rows activity to remove the duplicates
• Then get the count

dt.Rows.Count

[ImPratham45 (Prathamesh Patil)]

Use Read Range
Then use

Dt.DefaultView.ToTable(True,“Case no.”).Rows.Count

[Edd_0820 (Eddie_wan)]

If i want to ignore “C” and "H’

how can i revise the formula?

Thank you

[ImPratham45 (Prathamesh Patil)]

@ImPratham45

DT2=Dt.DefaultView.ToTable(True,“Case no.”)

then use Filter datatable or select method to filter it out
In filter datatable use that DT2 and use remove condition with column name “Case no.” = “H”
or “Case no.” = “I”

Then use DT2.rows.count