Menu
Ask a question Report

Help with filtering not working

- - Latest reply: ac3mark
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
 - Mar 14, 2019 at 02:54 PM
Excel Ask a question Report
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

System Configuration: Android / Chrome 72.0.3626.121
See more 

1 reply

Report Respond to ac3mark
Posts
13031
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
 1568
0
Thank you
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!!
Respond to ac3mark
Reply Ask a question