View original (French)

Need help with filters

trachemys63 Posted messages 30 Status Membre -  
eriiic Posted messages 24581 Registration date   Status Contributeur 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 réponses

Réponse 1 / 4
Raymond PENTIER Posted messages 58546 Registration date   Status Contributeur Last intervention   17 474
 
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
Réponse 2 / 4
Vaucluse Posted messages 27336 Registration date   Status Contributeur 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
Chiron_67 Posted messages 3 Registration date   Status Membre 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
Réponse 3 / 4
eriiic Posted messages 24581 Registration date   Status Contributeur 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
Réponse 4 / 4
trachemys63 Posted messages 30 Status Membre
 
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
eriiic Posted messages 24581 Registration date   Status Contributeur Last intervention   7 281
 
Not hello either!!!

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