Problem when count the number in column

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)

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

3 Likes

hi @Jan_Brian_Despi

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

Hmm.

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

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

Let me check other ways :slight_smile:

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

Thanks you so much but it has problem.

Pls kindly check as below.

Do you use the same excel file for that?

Hi @Jan_Brian_Despi

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

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

Hi @Jan_Brian_Despi

Thanks you so much ^^

1 Like

You’re welcome :slight_smile:

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