Thanks Domenic, I appreciate the reply but the doesnt seem to be
working.

Heres an example:

Job Number Customer Order Ref/Number
1 United 1
2 Hoyer jimmy
3 United 1
4 Hoyer dave jones
5 Deltank 75858
6 United 2
7 United 3

The result of the formula should be 1, i.e. there is 1 order number for
United that has been duplicated and if I changed the order number for
job 7 to 2 the result would be 2.

Thanks again for the replies, this is really baffling me!!!

John


--
johncassell
------------------------------------------------------------------------
johncassell's Profile: http://www.excelforum.com/member.php...o&userid=25016
View this thread: http://www.excelforum.com/showthread...hreadid=511027