Hi all,

I feel there is a simple solution to this problem but I can't figure it out, i wonder if you guys can help me?

Column A: Column B: Column C: Column D:

11 A A
22 A B
33 B C
44 C D
55 C
55 D


Column C is blank. Column D is Column B having removed duplicates.

In column E, I want a formula that indicates where each corresponding letter in Column D, has more than one column A value. I.e. E1 should read 2 because of 11 in A1 and 22 in A2.

And the rest should read E2=1, E3=2, E4=D.

I hope this makes sense.

I look forward to your help, Thanks