Count multiple entry

[#1]

I would like to count the no. of accounts attended by an agent. Event the agent have place 2 entry the report should only count as 1.

Moreover, I want to count account with action code only. Any entry without action code to be excluded from the count.

Require assistance base on the sample given..

[tresB · Accepted solution]

May be like attached sample?

[#3]

Thanks a lot!!