Forum Discussion
FILTER() is not working in OneDrive
Hey guys, anyone knows what could be the reason why FILTER formula does not work when I uploaded the file to the OneDrive. It works perfectly when I open the file in local excel but not OneDrive. No ...
Hi mathetes, thank you for your reply. You mean I can try to amend the formula to FILTER(D55:D69,G55:G69>0 that's it?
Jesling As mathetes suggests the formula is technically correct, but I would like to add that it isn't very meaningful. The portion "FILTER(D55:D69,G55:G69<0)=0" will ALWAYS return FALSE if at least one match is found, and then the second filter will be applied. Or it returns an error if no items are found that match the criterion of being <0. Then the IFERROR function kicks in.
You can use the third (optional) [if_empty] argument of the FILTER function to capture instances where no matches are found and can re-write the formula to:
=FILTER(D55:D69,G55:G69<0,"")