Forum Discussion

DavidNegranu's avatar
DavidNegranu
Copper Contributor
Jul 06, 2019

How to find out what filters were selected when inputting data

I am working on a database and I am inputting data in new columns based on other data within the spreadsheet.

 

When inputting data into one of my columns I believe I accidentally had a filter (or combination of filters) selected meaning that a significant sample of qualifying data for input has been missed. However on rectifying this, the unknown filter actually produced significantly better results so I wondered if it was possible to work out what filters were enabled when I initially input my data?

 

I have a version of the spreadsheet with the initial entry (but all filters cleared) and a version of the spreadsheet which has been completed correctly.

1 Reply

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    You would need to have a copy which still has those filters applied.

Resources