There can never be a BOL on more than one carrier.

Thanks for the help.

"Ron Coderre" wrote:

Regarding:
SUMPRODUCT((A2:A8=E2)/COUNTIF(C2:C8,C2:C8))

Possible issue if the same Bill of Lading ref could exist for more than one
shipper. Not enough information to determine if there's any exposure on that,
though.

***********
Regards,
Ron

XL2002, WinXP


"Harlan Grove" wrote:

"T. Valko" wrote...
Entered as an array using the key combination of CTRL,SHIFT,ENTER
(not just ENTER):

E2 = AVRT

=SUM(--(FREQUENCY(IF(A2:A8=E2,MATCH(C2:C8,C2:C8,0)),
MATCH(C2:C8,C2:C8,0))0))
....

Maybe, but a simpler, nonarray formula would also work:

=SUMPRODUCT((A2:A8=E2)/COUNTIF(C2:C8,C2:C8))

This would only break down if the col C values could start with
comparison operators (<, =, ) or include wildcard characters.
Actually, wildcard characters could also screw up the MATCH calls.