Forum Discussion
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 col...
- Feb 19, 2024
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.
Mark_Stoneking
Feb 19, 2024Copper Contributor
Maciej,
Thanks for responding. I tried to drag and drop my file, but it won't accept .xlsx files... any thoughts on what I'm doing wrong there?
I'm using the filter function to filter an array. I'm not sure what the # symbol is doing in your formula. If you can help me sort out my file attaching issue I'll share my file.
Thanks
Maciej_Kopczynski
Feb 19, 2024Brass Contributor
Try opening the reply box in full text editor. Then drag the file into to drop space. It should work just fine. Files with .xlsx extensions should have no restrictions.