I know I'm going to kick myself when this gets resolved, but I'm having a bit of a brain fart right now. I'm trying to get the lowest non-blank value in a particular range (columns A-E).
[A]@row=18, [B]@row=16, [C]@row, [D]@row, & [E]@row are all blank. All five rows are products of column formulas. Basically, there are a bunch of IF( statements, and the value-if-false is "", which is why [C]@row, [D]@row, & [E]@row are all blank.
Here is the formula I'm using:
=MIN(COLLECT([A]@row:[E]@row,[A]@row:[E]@row,<>""))
The formula should ideally return with a value of 16, but it's coming back with a 0 value. I tried making dummy duplicate columns [A.Dup] through [E.Dup] and manually inserting the 18, 16, blank, blank, blank into the @row cells, just to test out my syntax. The formula worked fine with the dummy columns, but is not working right with the real columns that have formula-derived values. So I'm guessing there needs to be a VALUE( somewhere in the mix?
What needs to be changed in my formula to make this work? Thanks in advance.
