Problem when count the number in column

Learn Academy Feedback
1

Hi everyone.

My process can counted how many text appear in column… but it can not counted the number as below picture and attached file.

I don’t know why…Pls kindly support me.

Thanks in advance!data.xlsx (8.5 KB)
Count in Column.xaml (11.9 KB)

1
11920×1080 189 KB

2

Hi @trunghai,
I ran the code that you uploaded and it works. Here is the screenshot of the excel output:
works

3 Likes
3

hi @Jan_Brian_Despi

On my PC it not run exactly when count the number :slight_smile:

4

Hmm.

5

@trunghai,
Have you tried using “333” instead of 333 in the Filter Data Table activity?

6

Hi @Jan_Brian_Despi

I have tried before but still same ^^

I want to check and count total of number “333” in the column and then input result in the excel file ^^

1 Like
7

Let me check other ways :slight_smile:

8

Hi @trunghai
Please check this one:
Count in Column_Final.xaml (11.7 KB)
If this helps, please mark this one as the solution. Thank you!

1 Like
9

Thanks you so much but it has problem.

Pls kindly check as below.1

10

Do you use the same excel file for that?

11

Hi @Jan_Brian_Despi

I’m using the excel file as attacheddata.xlsx (8.6 KB)

12

Oh okay. Got it! :slight_smile:
Please try this one: Count in Column_Final.xaml (11.7 KB)

If it works for you, please mark this as the solution. IF EVER :smile:

3 Likes
13

Hi @Jan_Brian_Despi

Thanks you so much ^^

1 Like
14

You’re welcome :slight_smile:

15

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.