Excel filters are not working
luigid5
-
eriiic Posted messages 24581 Registration date Status Contributor Last intervention -
eriiic Posted messages 24581 Registration date Status Contributor Last intervention -
Hello,
When I want to display only certain data in a column, I click on the filter and select the value I want to appear. So far, so good!
Unfortunately, unchecked values still appear starting from the same row. It's as if the filter only applies to one entry of my spreadsheet.
If anyone knows a solution, I would appreciate it!
Configuration: Windows / Chrome 54.0.2840.99
When I want to display only certain data in a column, I click on the filter and select the value I want to appear. So far, so good!
Unfortunately, unchecked values still appear starting from the same row. It's as if the filter only applies to one entry of my spreadsheet.
If anyone knows a solution, I would appreciate it!
Configuration: Windows / Chrome 54.0.2840.99
1 answer
-
Hello,
You probably have a blank row; Excel considers that beyond this, there are no more data in the table.
eric
--
By trying continuously, we eventually succeed.
So the more we fail, the more chances we have that it will work. (the Shadoks)
In addition to thanking (yes, it does happen!!!), remember to mark it as resolved. Thank you.-
Thank you Eric for your quick response! It really helps me
One last little question:
I have an address column. In this column, there are a certain number of cells that contain the address number twice. For example: "3 3 rue dubois" instead of "3 rue dubois". Do you know a formula to remove the extra number in the affected cells?
Thank you in advance! -
-
