Forum Discussion
How to Edit Database (or a different solution) for FILTER formula?
I have a FILTER function pulling data from one database worksheet to 9 different worksheets based on 2 criteria that works great, except now the data needs to be edited in my database worksheet and when I edit the data I get #N/A everywhere in the worksheet. Is there a different function I should be using or a way to allow me to edit my source data?
2 Replies
FILTER() doesn't prevent editing of the source, perhaps you break condition. Will it be possible to share the sample?
Is your source data is formatted as an Excel Table? If not, format the source data as an Excel Table and then use the Table Structural reference in the Filter formula. The advantage of using an Excel Table is, it is self-expandable if you add more data down the rows.
