Forum Discussion
4cmh
Mar 18, 2025Copper Contributor
FILTER Function Help; Filtering on a column with a Formula
I'm attempting to use the FILTER function on a table in a different sheet. I've confirmed that the FILTER function doesn't need to be used in the same sheet containing the table. I'm assuming the issue is that the column uses a formula OR maybe the data type resulting from the formula.
Sheet 1: Column E Formula is =C2=D2
Previous versions of Column E Formula were:
- =EXACT(C2,D2) (Ran into case-sensitivity issue)
- =IF(C2=D2, TRUE, FALSE)
This column is confirming if the email in Column C (Current Email) & D (New Email) match. If not, then the user can easily identify which rows need to be updated.
Sheet 3: =FILTER('1. Current FDM List'!A2:E166, '1. Current FDM List'!E2:E166=FALSE, ""). I also tried =FILTER('1. Current FDM List'!A2:E166, '1. Current FDM List'!E2:E166="FALSE", "")
Both result in a #N/A error. Any help is appreciated.
Note: I know I can manually filter Sheet 1 to show the rows with FALSE, but I'm attempting to have this tool do the work itself so it's as easy as possible for my team/ppl who aren't as excel savvy.
- 4cmhCopper Contributor
That was exactly it. Thank you!
Inspect column E on the '1. Current FDM List' sheet. Does any of the cells contain #N/A?