Skip to Content
0

Count duplicities in column

Nov 24, 2017 at 03:13 PM

31

avatar image
Former Member

Hello gurus,

I would like to ask you for your help,

I want to create column with quantity of the values from "Ref" column, but I need quantity number in each row.

I tried formula like "=Count(Ref) In (Ref)" or "=Count(Ref;All) ForAll (Ref)" but it's not working

Thanks for your answers

count.png (47.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
AMIT KUMAR
Nov 24, 2017 at 03:27 PM
0

try this.

=count(ref;all) in (ref)

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

It's working, thank you!

0