Count the type of letter

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

image

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

Use Read Range
Then use

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

2 Likes

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

how can i revise the formula?

Thank you

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