Automatic Filter by rows and columns

[dadou]

Hello,

I'd like to make an automatic filter in a worksheet by row and by columns.

I explain :
Here is my worksheet for example
Name application1 application2 application3 application4
toto X X
tutu X X X X
titi X
tyty X
toutou X X
tyuiop X


I'd like to know for the user titi, what applications (marked as "X") he has on his computer.

Anyone has an idea please to help me ?
I have several files and lots and lots of lines and columns and i'd like to make comparisons of values.

[RobDog888]

Welcome to the Forums.

You can use the AutoFilter menu item. Tata > Filter > Auto Filter...
If you use it it can filter based on the first row as the labels. Then just click
the dropdowns to filter by whatever criteria you want.

HTH

[dadou]

Hello the forum

Thanks for your answer,
But i knew this solution, which is the excel standard auto filter function.

In my example,
[IMG]d:\temp\example.jpg[/IMG]

I would like to filter all values for User2.

But i also want to only display automatically (and not by defining a column size to 0) columns marked as "X".