Hi,
I'm having a bit of trouble creating an array formula
I have some data in my sheet like this;

Reference Type
11KING DD
11KING CC
13MANA DD
13MANA DD
23WES1 CH
2BENTE DD
2BENTE DD
2BENTE CH
2SIMP1 DD

Next to each row I want a '1' displayed if the reference has more than
1 type.
i.e a 1 should be put next to the accounts '11KING', and '2BENTE'.

Cheers
Tony