Forum Discussion

4cmh's avatar
4cmh
Copper Contributor
Mar 18, 2025

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.

  • Inspect column E on the '1. Current FDM List' sheet. Does any of the cells contain #N/A?

Resources