View original (French)

Partial data consideration by the filter function

Solved
identifiant-comment Posted messages 351 Status Membre -  
 Eric2 -
Hello,

In an Excel sheet, the filters do not account for all the cells in my spreadsheet and I can't explain why.
I haven't found any clues on Google or in the resolved posts of this forum. Does anyone have an idea?

Thank you in advance!

Configuration: Windows 7 / Firefox 26.0 / Excel 2007

4 réponses

Réponse 1 / 4
eriiic Posted messages 24581 Registration date   Status Contributeur Last intervention   7 281
 
Hello,

why a filter doesn't work if only the header row is selected
one explanation could be that rows 3 to 1198 were selected when the filter was applied and you just don't remember that or you didn't pay attention (due to a copy-paste, for example). And you completed the others afterwards.

eric

In addition to the thank you (yes, it is done!!!), please remember to mark it as resolved when it is the case (at the top near your title).
Thank you
10
Le Pingou Posted messages 12375 Registration date   Status Contributeur Last intervention   1 476
 
Hello eriiic,
I have a doubt, the filter is on the range [A10:H10], it always goes to the first row of a selection..! However, there must be a value in each cell of the filtered row..!
Friendly regards.
The Penguin
-1
identifiant-comment Posted messages 351 Status Membre 54
 
Hello eriiic,

That must be it! Thank you!
0
eriiic Posted messages 24581 Registration date   Status Contributeur Last intervention   7 281
 
I have a doubt, the filter is on the range [A10:H10], it always applies to the first row of a selection..!
Let's say rows 2 to 1198 then, the header row copied-pasted as well... ;-)
eric
0
Le Pingou Posted messages 12375 Registration date   Status Contributeur Last intervention   1 476
 
Thank you eriiic,
I'm still on cloud nine.
The Penguin
0
Eric2
 
Excellent answer !! I didn't know that the filter acted on the current selection! And to think I had been facing this problem for years :)
0