How to find count of a value?

Help Studio
1

How to find count of value in excel with using IF condition?

2

Hello @taruna.mehra

You are looking to take which count either number of rows or the number of cells. Can you please be more specific on what you are looking for

Regards,
Venkatesh R.

3

Hi @taruna.mehra

  1. Read Range and store in the variable"DT"
  2. If you need Row
    • DT.Rows.Count
  3. If Column
    • DT.Columns.Count

OR
4)You need a count for specific fields
-You can use “Filter Data Table” and you can take the count you want

Thanks and Regards
Sudharsan Ka

4

Hi @taruna.mehra

Here is the sample workflow
excelCounts.xaml (6.8 KB)

Hope this will work!
Let me know if you face any issue

Regards
Gokul

5

This I have done and wanted to try if else condition

6

Hi

I wanted to see how many times one value has been repeated in a data table.

7

@taruna.mehra
Can you give overview of the task?

8

Yes sure. I wanted to count how many times one name has been repeated in a data table.

Sorry I am learning UiPath and it’s new to me.

9

Hi @taruna.mehra

As @Sudharsan_Ka suggested by point 4 you can give a try with filter datatable activity or Select method.
Use can try select method like below.

DT.Select("[YourColumname]='yourSearchvalue'”).Count

Regards

10

Okay Then Try this

  1. Read Range and store in the variable"DT"
  1. For Each row in DT your Variable Name
  2. If Condition: row(“Name”).Contains(“You can give the name that you want to count”)
    True:Assign an Integer variable (Count =0 as default) in the Variable panel
    Assign Activity :Count = Count +1
    Else: Continue Activity
11

Thanks and will try this for sure. Will let you if it works smoothly

12

Sure

Let me know this works for you