•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
FILTER not working with a column that's a formula?
Our take
Are you facing challenges with the FILTER function when incorporating a formula-based column? This issue often arises when trying to create a shadow table that relies on a calculated column, such as Column E in your example. While FILTER works seamlessly with standard data in Columns A-D, the introduction of a formula can lead to an #N/A error. Understanding the nuances of how FILTER interacts with formula-driven data is essential for navigating these complexities and ensuring your data manipulation goals are met.
Say I have a table with 4 columns, and I add column E that's a formula. I want to create a shadow table using the FILTER function based on this Column E. Is that not possible? I am able to get the formula to work when I just build it off Columns A-D. But when I expand it to E, it results in an #N/A error.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience