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...
Lukereeves Function structure for FILTER() is different in google sheet and excel. So, share few sample data as well as your faulty formula so that we can correct it.
- 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?Lukereeves Then the underlying data contains #N/A.
- Thanks for your time, sometimes just need to bounce off someone, all good now working.
