thans alot Tom you're the man!! (Btw my name is also Tom + Ole :) )

"Tom Ogilvy" wrote:

=Min(if(B2:E2=A1,B4:E4))

entered with ctrl+Shift+enter rather than just enter since this is an array
formula.

--
Regards,
Tom Ogilvy


"fiur" wrote:

Hi I got an problem....
I wanna compare cell a1 with b2:e2 (if any of those cells are equal) then
find minimun value in cell b4:e4

of do I do that.......?