count of values

Shiva

New Member
hi all,

i want how many times the value is repeated in separate column. i tried using loop and count+1 but the value is storing in last row. can anyone help me with this...

regards,
shiva.
 

Attachments

  • Capture1.PNG
    9.1 KB · Views: 24
  • Capture2.PNG
    10.1 KB · Views: 24

Sukesh Kumaru

Active Member
Hello,
where you are searching for "collection contains value" for "Coll2" and how did you get the value 5 in count column last row of coll2.
 

Shiva

New Member
hi sukesh

in collection "coll1.name" i have repeat values so first eliminated duplicate values and stored in "coll2.name" after that iam trying to get count of repetitive from "coll1.name". so it is counting repetitive value and storing in last row of "coll2".
 

izeekhan

New Member
Hi

Gave it a go and it seems to have worked.

Thanks
 

Attachments

  • Names Counter.PNG
    39.9 KB · Views: 25
  • Names Counter.txt
    14.1 KB · Views: 22
Top