Skip to Content
0

Formula to Count rows in a table by qualification

Mar 28, 2017 at 01:44 PM

27

avatar image

Hi experts,

Please provide the solution how to better count rows in table with some qualification.

Here below my example with rows in table

ID Text Date Comment NewColumn(Count)

10001 test1 12/12/12 terter (need to be 2 as ID duble)

10001 test2 12/11/11 terterte (2)

10002 gdfgdf 13/11/12 gdfgdfgdf (1)

10003 gfdbvcdf 14/11/12 gjtrhtrdfk (1)

10004 gdfgdf 12/11/12 cvbnjhkrt (1)

10006 utr45 11/10/10 ggndfmgn (2)

10006 utr67 11/11/11 jfdgnjdfjgdf (2)

Count depend on ID

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

AMIT KUMAR
Mar 28, 2017 at 01:55 PM
0

use this.

=Count([ID];All) In ([ID])

Share
10 |10000 characters needed characters left characters exceeded
Pavel Prokoshev Mar 28, 2017 at 03:36 PM
0

Many thanks, Amit!

It really works!

Share
10 |10000 characters needed characters left characters exceeded