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
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
Hi @Edd_0820,
dt.Rows.Count
Use Read Range
Then use
Dt.DefaultView.ToTable(True,“Case no.”).Rows.Count
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