•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
Tagged with
#AI formula generation techniques#formula generator#rows.com#financial modeling with spreadsheets#Excel compatibility#cloud-based spreadsheet applications#Excel alternatives for data analysis#Excel alternatives#FILTER function#column E#formula##N/A error#shadow table#formula error#table#Excel#formulas in Excel#Columns A-D#data filtering#spreadsheet