Filter two vertical tables on the same sheet
Koelon
Posted messages
26
Status
Membre
-
Raymond PENTIER Posted messages 58550 Registration date Status Contributeur Last intervention -
Raymond PENTIER Posted messages 58550 Registration date Status Contributeur Last intervention -
Hello,
Is it possible to filter two vertical tables on the same sheet?
I can apply two different filters to each of my tables, but when I filter one, it hides rows that might be important for the second table.
Thank you :)
Configuration: Windows 7 / Chrome 39.0.2171.71
Is it possible to filter two vertical tables on the same sheet?
I can apply two different filters to each of my tables, but when I filter one, it hides rows that might be important for the second table.
Thank you :)
Configuration: Windows 7 / Chrome 39.0.2171.71
3 réponses
Hello,
Could you add a column containing "tablo1" or "tablo2" to differentiate the rows and arrange your tables diagonally in blocks?
This way, when you want to work on a table, you first filter by the added column and then by the fields of the chosen table.
In the first row, you will have the fields of each table plus the added field.
You split your active sheet and vertically juxtapose the 2 windows that you arrange according to the frozen panes.
Best regards
Could you add a column containing "tablo1" or "tablo2" to differentiate the rows and arrange your tables diagonally in blocks?
This way, when you want to work on a table, you first filter by the added column and then by the fields of the chosen table.
In the first row, you will have the fields of each table plus the added field.
You split your active sheet and vertically juxtapose the 2 windows that you arrange according to the frozen panes.
Best regards
Hello Koelon.
Why are you surprised by the result?
Filtering means hiding rows: So if your first filter hid row 9, it's obvious that everything in that row is hidden! It's logical, isn't it?
--
Retirement is great! Especially in the Caribbean... :-)
Raymond (INSA, AFPA, CF/R)
Why are you surprised by the result?
Filtering means hiding rows: So if your first filter hid row 9, it's obvious that everything in that row is hidden! It's logical, isn't it?
--
Retirement is great! Especially in the Caribbean... :-)
Raymond (INSA, AFPA, CF/R)
Hello to both of you & thank you,
It is indeed logical, but I would like to find a way to filter each table individually.
Each table will take elements from other tables to ultimately form a logbook. I want to filter this logbook to display only the important elements, making them visible at a glance.
Do you think it's possible?
It is indeed logical, but I would like to find a way to filter each table individually.
Each table will take elements from other tables to ultimately form a logbook. I want to filter this logbook to display only the important elements, making them visible at a glance.
Do you think it's possible?
I'm surprised, I see 3 tables with the same structure!!
Put them one below the other and add a distinguishing field.
Explain a bit why you have this layout. Is there any benefit for you?
Best regards