Thanks,

This formula worked, with the exception I couldn't do all 7 ranges in one
formula, I had to sum each array and then set results into 7 cells next to
each other then min the results.

"Dav" wrote:


Not a complete answer but the following give the correct answer if each
of your 7 ranges contains a value greater than 0, otherwise if any of
the ranges doesnot it returns 0

if entered as an array crt sht enter

=MIN(MIN(IF(D162:D1810,D162:D181)),MIN(IF(D136:D1 550,D136:D155)),MIN(IF(D110:D1290,D110:D129)),MI N(IF(D84:D1030,D84:D103)),MIN(IF(D55:D770,D55:D7 7)),MIN(IF(D32:D510,D32:D51)),MIN(IF(D6:D250,D6: D25)))

I am still thinking on it

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=535562