Counter Dought

[supu123 (supriys)]

Hii,

The remark field has both ticket no and entry count i.e ticket no:entry count
Now my query is the entry no should be is 0 for first 3 rows i have keep it “1” for next 3 rows i.e 5,6,7
How do I do that
Thanks and Regards,
Supriya

[Joeri_Rethy (JR)]

Mind rephrasing your question? I’m not sure what you are asking. But it doesnt seem to complicated data though.

[msan (Michel SAN)]

Hi,

How is entreyCount defined?

[supu123 (supriys)]

Hii
Consider 2 and 5 row the subject and body is same so entry count should become 1
nxt 2 and 5 the entry count should be 1 it is entering second time

Thanks and Regards,
Supriya

[msan (Michel SAN)]

Well, at first glance, with x as the rowNumber

• I’ll add a column for the entryCount (let’s say E) with the formula =Ax&"|"&Bx

• for the remark column (let’s say F) I’ll use the formula =Ax&":"&COUNTIF(C2:C2;Cx)

The latest formula count the occurences of the combination in preceding row the current one included.

[Palaniyappan (Forum Leader)]

buddy @supu123

Kindly find the attached xaml buddy
Its resolved

Counter.zip (11.7 KB)

Hope would help you
Cheers