Forum Discussion
FILTER function returning VALUE error
Hi all,
I am doing a very simple FILTER function and cannot figure out why it is not working.
Below is my data I want to filter. "ID" column is column A, "Eligible?" column is B, data are in rows 2-6.
| ID | Eligible? |
| 100 | TRUE |
| 101 | TRUE |
| 102 | TRUE |
| 103 | TRUE |
| 104 | FALSE |
My formula:
=FILTER(A2:A6,B2:B6=TRUE,"")
Returns a #VALUE! error, rather than the IDs 100-103 as I expect. Can someone help me understand why?
I have tried without the =TRUE, without the last argument, command+shift+return on Mac to make it an array function, and other things. I am stumped! Please help :) Thank you!
1 Reply
It should work:
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
