View original (French)

Partial data consideration by the filter function

Solved
identifiant-comment Posted messages 351 Status Member -  
 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 answers

  1.
    eriiic Posted messages 24581 Registration date   Status Contributor 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
    1. Le Pingou Posted messages 12275 Registration date   Status Contributor Last intervention   1 477
       
      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
    2. identifiant-comment Posted messages 351 Status Member 54
       
      Hello eriiic,

      That must be it! Thank you!
      0
    3. eriiic Posted messages 24581 Registration date   Status Contributor 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
    4. Le Pingou Posted messages 12275 Registration date   Status Contributor Last intervention   1 477
       
      Thank you eriiic,
      I'm still on cloud nine.
      The Penguin
      0
    5. 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