How to count this conditions

I have some data and I would like to count the number of “Ven+M”

How many duplicate numbers are there? and keeps it to next step

ven+m
1000003301
1000003303
1000024101
1000024101
1000035901
1000035902
1000055901
1000055901
1000055901
1000055901
1000055901
1000055902
1000055902
1000055903
1000055903
1000055903
1000063603
1000063603
1000063603
1000208701
1000208702
1000208703
1000299901
1000299901
1000299903
1000299903
1000299903
1000590412

Hi @Beau_blue

Welcome to our UiPath Forum :slight_smile:

I think the easiest would be to use this activity first:


to remove all duplicate rows.

You can then count the remaining rows with a rather straightforward yourDataTableVariable.Rows.Count

Hi @loginerror
Thank you for your information .I m just a beginner for Uipath