=if(countif(range,ref#)1,-1,"No multiple occurrences")


"ells2812" wrote:


Hi,

What I want to do is get excel to compare a reference number to a list
of of reference numbers and if it is in the list more than once out put
-1.

I have been working on this for ages but cannot seem to find a way of
getting this to work.

If any one has any suggestions I would be very greatful.

Many Thanks


--
ells2812
------------------------------------------------------------------------
ells2812's Profile: http://www.excelforum.com/member.php...o&userid=32562
View this thread: http://www.excelforum.com/showthread...hreadid=523548