Mark_Stoneking

Feb 19, 2024Copper Contributor

# 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 column to turn those zeros into 8's, but MIN() only sees the 8's. I've specified the cell to be a number, but it doesn't seem to be working. I can share the file

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.