What if I am selecting specific cells in a row, (A1,D1,G1...) and not a
RANGE. I am trying to create a column with the lowest price for each item in
a given row. This worksheet will have many ROWS.

"Max" wrote:

Try in say B1, array-entered (press CTRL+SHIFT+ENTER):
=MIN(IF(A1:A10<0,A1:A10))
where A1:A10 is the range which may contain zeros
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"seastheday" wrote in message
...
I want create a worksheet which will locate the smallest number in a given
range but I don't want it to locate any cells which equal zero. (Some
cells
make be blank)