Try this array formula (confirm with Ctrl+Shift+Enter, not just Enter):
=MIN(IF(A1:D1000,A1:D1000))
Regards,
KL
"Pipeladylu" wrote in message
...
I found a formula for determining the lowest costs from several columns,
but
I cannot get it to work in my worksheet. This is nearly 1000 lines long.
I
want to search 4 columns and get the lowest cost excluding 0. Any
suggestions would be greatly appreciated. Thanks!!
|