how to find the result based on 3 factors?

[emmr]

Hello Everyone;

i've attached a sample file for your convenience. how can i get the result based on 3 factors.

here on a particular date if items count is duplicate then remarks "system" will be accepted & others will be rejected.
on a particular date if items count is duplicate & remarks also duplicate then one will be accepted & others will be rejected.

thanks in advance