Count the number if times a unique number appears in a list

[p45cal]

Unfortunately no, its the unique or distinct count I need of column c, where the fall under the same number shown in column B

How can ANY result be 0?!
My results are a distinct count of container number for every MAWB/MBL

You will note each container number that is the same number is only counted once, as its the same container container number, so its the distinct count I need.
For example, from the above example under MAWB/MBL HLCUGDY240144047, I have only 2 container numbers, so the excel formula I need is to show 2

This is a screenshot from my results; it looks like it's a 2 to me.

2024-04-12_114254.jpg