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...
Ok, it works fine with a clean sheet, no issues.
Just used this formula on the same sheet and a different sheet all good.
=FILTER(B3:D22,D3:D22<11)
On my sheet I have several sheets copied from other workbooks, I pull the data required into a new sheet called workings, I then want to filter this to only show me values less than 0.
I just started started again, and cleaned up things, I then used this formula (same as the one above) =FILTER(Workings!A7:P15250,Workings!P7:P15250<0)
It always returns #NA
Formatting issue?
Can i post the spreadsheet?
Just used this formula on the same sheet and a different sheet all good.
=FILTER(B3:D22,D3:D22<11)
On my sheet I have several sheets copied from other workbooks, I pull the data required into a new sheet called workings, I then want to filter this to only show me values less than 0.
I just started started again, and cleaned up things, I then used this formula (same as the one above) =FILTER(Workings!A7:P15250,Workings!P7:P15250<0)
It always returns #NA
Formatting issue?
Can i post the spreadsheet?
Lukereeves Then the underlying data contains #N/A.
- Thanks for your time, sometimes just need to bounce off someone, all good now working.
- Yes I just ran through some tests, so looks like will need iferror to fix.