Try putting a value of not x in A1:A6 with a value in B smaller than all the
values associated with x. Still works?

--
HTH

RP

"Ron Coderre" wrote in message
...
That is . . .
=MIN(IF(A1:A6="x",B1:B6))works for me with and without CSE

--
Regards,
Ron