How to find out what filters were selected when inputting data

Copper Contributor

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
You would need to have a copy which still has those filters applied.