Quote Originally Posted by Aussiebear View Post
Your request was clear enough, its just the sample data you initially provided that was misleading. Did you try P45cals solution? From the workbook presented it appears you have done nothing. My issue is with the Counting, given that the count is duplicated. We can get around this by creating unique item listings for both columns and the count therefore is far more accurate. Which you can find in my second workbook.

However since you said you want to leave the data as is then so be it.

In short, in cell C2 enter the following formula 
=Countifs($B$2:$B$136,B2,$C$2:$C$136,C2)
and fill down. You simply need to adjust the range to suit your actual data.

Hi,

Yes I did try P45 solution but this doesn't give a unique count, it just totals, which is not what I need to do, I need to count the total number of unique container numbers that are under the same Mawb number.

S0 for example

MAWB/MBL
Container Number
Container Count



MEDUD8472729
TRLU4818477
0



MEDUD8472729
TRLU4818477
1
The above data is telling me I moved 1 container against Mawb/MBL MEDUD8472729.


If I use P45 solution I get the below:

MAWB/MBL
Container Number
Container Count



MEDUD8472729
TRLU4818477
2



MEDUD8472729
TRLU4818477
2
Which gives wrong values

If I have the same container number displayed, this needs to be 'counted' as 1.

Hope that makes sense?

And that's for your patience everyone.