You're welcome, Alex, and thanks for the feedback :-)

Since negative prices and 0 are not an option (unfortunately :-),
here is an alternative to Max's formula:

=IF(SUM(B2:M2)=0,"No stock!",INDEX($B$1:$M$1,MATCH(MINA(B2:M2),B2:M2,0) ))

LeoH


"Alex" skrev i en meddelelse
...
That worked perfectly thanks!! If no supplier has the stock, and therefor
no
prices have been entered can i display 'No Stock'?? Thanks Leo!

"Leo Heuser" wrote:

Alex