I want to find the lowest value in a column. I know to use MIN(A1:A100).
But the A1 column I want to use is partially populated; it has non-zero from A1 to A?, the rest of the cells in the column
are zero
So: A1 to A20 are non-zero; A21 to A100 are zero.
I wanted to use LOOKUP to return the cell in the column with the last non-zero value,
then use MIN to find the lowest value in the populated cells:
MIN(A1:last populated cell from LOOKUP)
But Excel keeps telling me =MIN(A1:LOOKUP(2,1/(A1:A100<>0),ROW(A1:A100))) is not a formula
"There's a problem with this formula.
Not trying to type a formula?" etc
Please tell me what I'm doing wrong.
I'm a newbie, so I'm here asking for your help.
Thank you for your help,
Tom
Bookmarks