•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