View original (French)

Need help with filters

trachemys63 Posted messages 30 Status Member -  
eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   -
Hello,

I am working with Excel 2010 and I have a little filtering issue. To make it simple, I have a table of staff records in which I have 4 groups.
I would like to create a filter on the first column to select the groups but also to remove the rows where there are empty cells (so they don't show up anymore since they correspond to staff members who never come, so from a practical point of view, they might as well not appear).
When I uncheck the "blanks" box, it also removes my header even though there are no empty cells!!!

http://servimg.com/image_preview.php?i=208&u=11099425

I think it's clearer this way

So my question is: how do I create a filter on two columns and not the whole table?
How can I keep the full title???

http://servimg.com/image_preview.php?i=209&u=11099425

Here is my approach

Thank you all!

Configuration: Windows 7 / Chrome 23.0.1271.97

4 answers

  1.
    Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
     
    Hello.

    We can't do anything with your photo!
    We need the Excel file itself to work on it.

    --
    Retirement is great! Especially in the Caribbean... :-)
    ☻ Raymond ♂
    0
  2. Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello
    maybe simply by placing your filter on line title No. 7 instead of line 1?
    try
    crdlmnt

    --
    are we not the only ones to understand what we are explaining?
    0
    1. Chiron_67 Posted messages 3 Registration date   Status Member Last intervention  
       
      I believe that’s good advice... to make a functioning table with filters, you always have to remember to use a clean header row: no merged cells, stay on a single row, avoid empty cells... With that, it should work...
      0
  3. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    Hello everyone,

    and if you want to, select A7:B7 before applying the filter for only 2 columns.

    eric

    --
    You should never respond to an unsolicited DM...
    Well, that's that.
    0
  4. trachemys63 Posted messages 30 Status Member
     
    I can't give the file, it's a confidential file.

    I'll try, but as soon as I want to apply the filter, it sticks to the top... grrrrrrrrrr
    0
    1. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
       
      Not hello either!!!

      And what if you read the answers?
      Select A7:B7 before applying the filter.
      eric
      0