I am trying to count the number of products per shipment, each occurrence of the same vessel name on the same date means a new product. So, in the example below, on the 10/06, Vessel A delivered three products, and Vessel B and C delivered one product each. How do I count these instances where “shipment_date=duplicate & vessel_name=duplicate”

Shipment date Vessel name
10/06 A
10/06 A
10/06 A
10/06 B
10/06 C

Unfortunately I can’t share the file itself, so hopefully this is a good enough explanation.

Thanks

Tried highlighting duplicate values in vessel name column. Also tried creating a countifs rule.