count total an unique value in a column

[Anonymous]

Hi everyone,

I want to count total a unque value in a column.

For example I have this

Column 1:     Column 2:

1                    11

1                    11

1                    11

1                    11

0                    5

1                    11

0                    5

0                    5

0                    5

1                    11

1                    11

1                    11

0                    5

1                    11

1                    11

1                    11

As you can see the number one occurs 11 times and the number 0 occurs 5 times. I want to see with a formula that 11 and 5 in each row. Can you guys help me out?

[v-shex-msft]

Hi @Anonymous ,

I'm not so clear for your requirement, can you please explain more about this with some expected result?

Regards,

Xiaoxin Sheng

[Anonymous · Accepted solution]

I allready have the right formula, but thanks for helping