Forum Discussion
Solved
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...
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.
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
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.
