Count the type of letter

Learn
#1

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

#2

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

#3

Use Read Range
Then use

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

2 Likes
#4

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

how can i revise the formula?

Thank you

#5

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