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.