Maybe:-

With your list in column A put this in B1 and drag down

=IF(COUNTIF(A1:$A$10,A1)1,1,"")

Mike

"bony_tony" wrote:

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