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

[arnelgp]

also, maybe you can use VBA?

[Scuba]

Hi all,

Sorry if my message is not clear, to try and clarify, the data in column B (MAWB/MBL) is a master file reference, under any given master file reference I could have instances where I have multiple container numbers (Column C 'Container Number').

I need to be able to count the unique number of time a container number is displayed in column C, that falls under the same master reference from column B.

I also need to leave the data as is i.e. I really need to find an option that works on the data as displayed, rather then doing further work first on the data.

This data is from a much larger data sheet, I just simplified it for the purposes of asking for help here.

I have managed to upload the file now, no idea why it didnt work before.

Regards

[Scuba]

Replying to Post 9.

This worked perfectly and displays the data I need, however, is there a way to do this via Excel rather then VBA?

Regards

Richard