Automatic Filter by rows and columns

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.

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

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".