•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?
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]
Want to read more?
Check out the full article on the original site
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