Home

How to find out what filters were selected when inputting data

%3CLINGO-SUB%20id%3D%22lingo-sub-740963%22%20slang%3D%22en-US%22%3EHow%20to%20find%20out%20what%20filters%20were%20selected%20when%20inputting%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-740963%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20working%20on%20a%20database%20and%20I%20am%20inputting%20data%20in%20new%20columns%20based%20on%20other%20data%20within%20the%20spreadsheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20inputting%20data%20into%20one%20of%20my%20columns%20I%20believe%20I%20accidentally%20had%20a%20filter%20(or%20combination%20of%20filters)%20selected%20meaning%20that%20a%20significant%20sample%20of%20qualifying%20data%20for%20input%20has%20been%20missed.%20However%20on%20rectifying%20this%2C%20the%20unknown%20filter%20actually%20produced%20significantly%20better%20results%20so%20I%20wondered%20if%20it%20was%20possible%20to%20work%20out%20what%20filters%20were%20enabled%20when%20I%20initially%20input%20my%20data%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20version%20of%20the%20spreadsheet%20with%20the%20initial%20entry%20(but%20all%20filters%20cleared)%20and%20a%20version%20of%20the%20spreadsheet%20which%20has%20been%20completed%20correctly.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-740963%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-742528%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20find%20out%20what%20filters%20were%20selected%20when%20inputting%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-742528%22%20slang%3D%22en-US%22%3EYou%20would%20need%20to%20have%20a%20copy%20which%20still%20has%20those%20filters%20applied.%3C%2FLINGO-BODY%3E
DavidNegranu
Occasional Visitor

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.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
11 Replies