Hi there
This array formula returns the smallest value, from cells in the column b range that contain values greater than zero and have blank cells next to them column A. At the moment, if all excel cells in the column b range that have a value greater than zero have non-blank cells column A, then i get #NUM!
How can I adjust this array formula so that instead of getting #NUM! in this circumstance, i get "Finished"?
There will always be a value greater than zero in the column b range.
{=SMALL(IF(A5:A1048576="",IF(B5:B1048576>0,B5:B1048576)),1)}
Thanks
stuartzz
Bookmarks