Hi all,

I have a simple excel sheet that I need some help with a formula, I require a formula that looks at column B, and then Column C and returns the number of how many containers numbers match.

I don't need the sum of the values, just how many times a given container number is displayed when it it covers or falls under the same number from column B, Unique count as it where.

I have given an example of what I am after as the fished result in column D.

For example cell B2 & B3 have same number and column C2 & C3 have same number so the unique count of the container number in Cell D2 & D3 is actually only 1 and so forth as you go down the list

I'm probably not explaining myself clear here but hopefully column D will show what I'm after.

I'm hoping one of you wizards in excel can help me with this?

Thanks you in advance