Forum Discussion
FILTER function
Hi, I have currently migrated from Googlesheets to EXCEL. I have an issue with the FILTER function, I have a simple formula that looks back at another sheet and returns any values less than...
Oops
=FILTER('PB 3 WORKINGS'!B3:E16000,'PB 3 WORKINGS'!E3:E16000<0)
Column E3 is a sum of 2 other columns.
Lukereeves The formula syntax seems to be correct and FILTER looks at the values of the cells to be included, not the formulas in those cells.
You say the function "does not return a value". But you don't specify the result that is being returned. It can't be just nothing. Perhaps a #CALC! error, meaning no matching records were found. If so, you may add a third optional argument specifying what needs to be returned if no matches are found.
Or do you get a dialogue box stating "There's a problem with this formula"? Perhaps you need you use a semi-colon rather than a comma to separate arguments in your local Excel set-up.