=MIN(IF(1/COUNTIF(A1:A10,A1:A10)=1,A1:A10))

entered with ctrl + shift & enter

if there can be blank cells within the range


=MIN(IF((A1:A10<"")/COUNTIF(A1:A10,A1:A10&"")=1,A1:A10))

--
Regards,

Peo Sjoblom


"Steve Haack" wrote in message
...
I am looking for a MIN function that will tell me the smallest number in a
column of numbers, but only if it is unique. For example, if the column
has 2
instances of the number 5, and it is the smallest, then I don't care, but
if
there is only one instance, then I want to know about it. Ideally, it
would
return the cell that it is in, rather than just the number.

Anybody know of something like that?

Thanks,
Steve