I've got a large excel spread sheet that I need to filter.
The spread sheet is a matrix - application functions listed by row and user id's by column with an X in the cells where there is an intersection.
What I want to be able to do is select the function and filter for all the columns that have an X in them in that row. that is Select a function and see a record of all the users with access to it.
Normally you can do it with the auto filter, but that works the other way around ( Select the column with the user name and filter for all the functions they have ). I can't transpose the sheet because there are more than 256 rows of data.
Does anyone know a way you can do this?
The spread sheet is a matrix - application functions listed by row and user id's by column with an X in the cells where there is an intersection.
What I want to be able to do is select the function and filter for all the columns that have an X in them in that row. that is Select a function and see a record of all the users with access to it.
Normally you can do it with the auto filter, but that works the other way around ( Select the column with the user name and filter for all the functions they have ). I can't transpose the sheet because there are more than 256 rows of data.
Does anyone know a way you can do this?
Comment