Forum Discussion

Mark_Stoneking's avatar
Mark_Stoneking
Copper Contributor
Feb 19, 2024

MIN() function not working on data returned from FILTER()

I'm trying to sort through data. I think what I'm trying to do is pretty simple. There's a field that has 0, 1, 2 or 3 in it. I'd like to find the minimum number that's not 0. I created a working col...
  • PeterBartholomew1's avatar
    PeterBartholomew1
    Feb 19, 2024

    Mark_Stoneking 

    The VALUE function converts a 'number' that is stored as a text string to a numerical value.  Something that puzzles me, though, is that I think MIN should coerce text to numbers where possible.

Resources