Help with filtering not working
Closed
Hello,
I am having issues with my excel at work we have about 8 columns an they have filters an when I type in data an click the filter to go to that data it is not there why? The older data is but nothing newer please help
I am having issues with my excel at work we have about 8 columns an they have filters an when I type in data an click the filter to go to that data it is not there why? The older data is but nothing newer please help
System Configuration: Android / Chrome 72.0.3626.121
Related:
- Help with filtering not working
- Safesearch filtering is on - Guide
- Filtering effects reels - Guide
- Content filtering android - Guide
- How to create Instagram filters with Spark AR Studio - Guide
- Take pictures with the black and white Snapchat filter - Guide
1 response
If you look closer, I think you will find the newly added values are in the filter, they are indexed in ascending order, not in the order in which they are placed on the sheet. So, if you have a column that is:
123
345
567
111
The filter index will be as follows:
111
123
345
567
Post back if this is not the case, or if it is!!
123
345
567
111
The filter index will be as follows:
111
123
345
567
Post back if this is not the case, or if it is!!